OceanBase Connector/J V2.2.7

Version information

• Release date: December 02, 2021
• Version: V2.2.7

Overview

OceanBase Connector/J V2.2.7 is fully compatible with the COM_STMT_PREPARE_EXECUTE protocol and the SEND PIECE feature that is based on the protocol. This version applies to general businesses.

Feature enhancements

• In Oracle mode, the SEND PIECE feature is disabled by default. You can configure useServerPrepStmts=true&usePieceData=true in the URL to enable this feature.
• In Oracle mode, the COM_STMT_PREPARE_EXECUTE protocol supports batch execution.
• In Oracle mode, the performance of the PreparedStatement.setBytes() method is optimized. For example, the time consumed for processing 32 KB data is reduced from 60 ms to 15 ms.
• The limitations on FetchSize are adjusted for Statement objects.
• The conditions for using useCursorFetch to retrieve the result set are adjusted.
• Streaming read is no longer supported in Oracle mode, which is consistent with native Oracle.
• A placeholder in the name format will be automatically converted into a question mark (?) for objects that are not procedures or functions.
• The default value of cachePrepStmts is changed to false, which is consistent with MySQL Java Database Connectivity (JDBC).

Bug fixes

• Fixed the issue where the data returned by the stmt.setBinaryStream() method is incomplete for RAW queries in Oracle mode.
• Fixed the issue where an error is returned when the setClob() method uses EMPTY_CLOB() as a parameter in Oracle mode.
• Fixed the issue where an error is returned when Localdatetime is used together with a timestamp.
• Fixed the issue where field mapping errors occur if column aliases are used in a MyBatis environment.
• Fixed the issue where, if a CLOB is inherited from a BLOB, a type judgment error occurs when the getObject() method is called.
• Fixed the issue where errors occur when OceanBase Connector/J is connected to OceanBase Database Proxy (ODP) by using the COM_STMT_SEND_PIECE_DATA protocol.
• Fixed the issue where an error is returned if the data type of a CLOB column is set to String when getObject() is called.
• Fixed the issue where an error is returned if usePipelineAuth=true is configured.
• Fixed the issue where errors related to the rewriteBatch parameter occur.
• Fixed the issue where setPort in OceanBaseDataSource does not take effect.
• Fixed the issue where uploading will fail if a CLOB column contains single quotation marks (').
• Fixed the issue where hints are commented out in Oracle mode.