OceanBase Connector/J V2.4.12|V2.4.19|OceanBase Connector/J |docs|OceanBase Documentations

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(), and getLength() methods of the ResultSetMetaData interface 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=true is configured.
Fixed the issue where an error is returned when the executeBatch() method is called with useServerPrepStmts=true&usePieceData=true&useArrayBinding=true configured.
Fixed the issue where an error is returned when the setFetchSize() method is called while the value of FetchSize is greater than that of MaxRows in 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 FetchSize is greater than that of MaxRows in MySQL mode.
Fixed the issue where an ArrayIndexOutOfBoundsException is thrown when the setCharacterStream(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 and useArraybinding=true is 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.