Version information
- Release date: August 2, 2024
- Version: V2.4.12
Overview
OceanBase Connector/J V2.4.12 readapts to the getScale(), getPrecision(), and getLength() methods of the ResultSetMetaData interface. It also ensures that the getProcedureColumns() method returns the correct result set in Oracle mode and optimizes the performance of the getDate() method.
New features
The new version readapts to the
getScale(),getPrecision(), andgetLength()methods of theResultSetMetaDatainterface based on the compatibility mode.The performance of the
getDate()method is optimized.
Compatibility changes
Product behavioral changes
The getProcedureColumns() method can return the correct result set in Oracle mode.
New URL parameters
| Parameter | Status | Default value | Description |
|---|---|---|---|
| obDateTypeOptimization (specific to OceanBase Connector/J) | New | False | Specifies whether the getDate() method obtains a value directly from a byte array instead of converting the value to a string and then truncating the string. |
| useNewResultSetMetaData (specific to OceanBase Connector/J) | New | False | Specifies whether metadata is compatible with MySQL Connector/J. |
Bug fixes
- Fixed the issue where the
recover()method returns an empty result set for eXtended Architecture (XA) transactions. - Fixed the issue where the error returned when OceanBase Connector/J connects to OceanBase Database V4.2.x is inconsistent with that returned when it connects to OceanBase Database V3.2.x in the ArrayBinding delete scenario where both the PreparedStatement and PrepareExecute protocols are enabled and
rewriteBatchedStatements=trueis configured. - Fixed the issue where an error is returned when the
executeBatch()method is called withuseServerPrepStmts=true&usePieceData=true&useArrayBinding=trueconfigured. - Fixed the issue where an error is returned when the
setFetchSize()method is called while the value ofFetchSizeis greater than that ofMaxRowsin Oracle mode. - Fixed the issue where an error is returned when a cursor is used to retrieve columns from an updatable result set while the value of
FetchSizeis greater than that ofMaxRowsin MySQL mode. - Fixed the issue where an
ArrayIndexOutOfBoundsExceptionis thrown when thesetCharacterStream(2)method is called to construct a CLOB. - Fixed the issue where an error is returned when the
executeBatch()method is called while both the PreparedStatement and PrepareExecute protocols are enabled anduseArraybinding=trueis configured. - Fixed the issue where the connection hangs if the obtained result set is empty when multiple threads use the same connection (
conn) in the PreparedStatement protocol. - Fixed the issue where the "Current position is after the last row" error is returned when a synonym of a complex PL data type is used to construct the input parameters of a stored procedure.