OceanBase Connector/J V2.4.14

• Release date: March 7, 2025
• Version: V2.4.14

Overview

OceanBase Connector/J V2.4.14 supports the Hong Kong Supplementary Character Set (HKSCS). It also provides the emulateLocators and locatorFetchBufferSize parameters to ensure correct conversion of BLOB data. The logic for matching and building anonymous array metadata caches is optimized to improve performance. A parameter is provided to control the maximum number of reconnection attempts, thereby enhancing the stability of the driver.

New features

• The emulateLocators and locatorFetchBufferSize parameters are provided to ensure that BLOB data is correctly converted by the getBytes() method.
• The maxReconnects parameter is provided to control the maximum number of reconnection attempts. This can avoid the StackOverFlowError error caused due to infinite reconnection attempts upon I/O exceptions when autoReconnect=true is configured.
• The HKSCS character set is supported for compatibility with OceanBase Database. To store characters in HKSCS or HKSCS31, set &characterEncoding=HKSCS/HKSCS31 in the URL and send set names hkscs/hkscs31 to OceanBase Database.
• The logic for matching and building anonymous array metadata caches is optimized. Specifically, if the array elements are of a basic data type, OceanBase Connector/J does not need to interact with OceanBase Database, thereby reducing the performance overhead.

URL parameter changes

The following URL parameters are added.

Bug fixes

This version fixes the following bugs:

• Fixed the issue where the value set by the setQueryTimeout() method is invalid for a cursor result set.
• Fixed the issue where the 5777 or 9747 error code is returned when the value set by the setClob() method is empty in a PL statement in Oracle mode.
• Fixed the issue where an error is returned when the getParameterMetaData() method is called if the stored procedure does not contain BEGIN in MySQL mode.
• Fixed the issue where the number of open cursors exceeds the limit when the executeBatch() method is called while cachePrepStmts=true is configured.
• Fixed the issue where the ORDER BY clause is incorrectly concatenated with input parameters on a cursor result set.
• Fixed the issue where the FOR UPDATE clause is incorrectly concatenated with input parameters on a cursor result set when the PreparedStatement protocol is enabled in Oracle mode.
• Fixed the issue where a pagination query statement is incorrectly concatenated with input parameters on a cursor result set when the PreparedStatement protocol is enabled in Oracle mode.
• Fixed the issue where the HAVING clause is incorrectly concatenated with input parameters on a cursor result set when the PreparedStatement protocol is enabled in Oracle mode.
• Fixed the issue where an error is returned if the equal sign (=) in call ?:=function(?) is not followed by a space.
• Fixed the issue where the ps.getMetaData() method returns NULL when it is called on a PreparedStatement object that represents a non-SELECT statement, with the PreparedStatement protocol enabled or both the PreparedStatement and PrepareExecute protocols enabled, which is incompatible with native MySQL.
• Fixed the issue where a syntax error of INSERT INTO...SET is returned when rewriteBatchedStatements=true is configured in MySQL mode.
• Fixed the issue where the number of returned rows is always -1 when DML statements containing the RETURNING clause are executed in a batch in Oracle mode.
• Fixed the issue where an error is returned when TRUNCATE is called on BLOB data stored by using OUTROW storage in Oracle mode.
• Fixed the issue where the rs.getClob().toString() method returns the class name, which is incompatible with native MySQL and Oracle.
• Fixed the issue where session variables are missing when the JDBC driver reconnects to the database after an SQL statement that exceeds the value of maxAllowedPacket is sent.
• Fixed the issue where text execution is not applied upon an exception when statements are executed in a batch, with the PreparedStatement protocol enabled and emulateUnsupportedPstmts=true configured.
• Fixed the issue where an error is returned when the output parameter type specified by the registerOutParameter() method is a complex data type and the method contains typeName in Oracle mode.
• Fixed the issue where an ArrayIndexOutOfBoundsException is thrown when a getXXX() method is called to obtain information about the target column, if the data type is binary_float or bianary_double and the PreparedStatement protocol is enabled, in Oracle mode.
• Fixed the issue where a parameter match error occurs if a in call p(a=>?) is not the first parameter in Oracle mode.
• Fixed the issue where the result of the free() method called on LOB data is inconsistent with that in native MySQL.
• Fixed the issue where the defaultFetchSize parameter cannot be set to Integer.MIN_VALUE.
• Fixed the issue where various getXXX() methods process data of the float, binary_float, and binary_double types in different ways in Oracle mode. This version applies a unified approach.
• Fixed the issue where, when the getLong() method is called on a float column to retrieve column values as long data, the precision of original column values is missing.