OceanBase Connector/J V2.2.7

Version information

• Release date: December 2, 2021
• Version number: V2.2.7

Overview

OceanBase Connector/J V2.2.7 is released to fully support the PREPARE_EXECUTE protocol and its SEND PIECE feature, addressing customer issues. It is ready for routine business use.

Feature enhancements

• SEND PIECE is disabled by default in Oracle-compatible mode. To enable it, set useServerPrepStmts=true&usePieceData=true.
• COM_STMT_PREPARE_EXECUTE supports batch operations in Oracle-compatible mode.
• The performance of PreparedStatement.setBytes has been optimized in Oracle-compatible mode, reducing the time consumed for 32K data from 60ms to 15ms.
• Adjusted the limit for Statement FetchSize.
• Adjusted the conditions for using useCursorFetch to read result sets.
• Stream reading is no longer supported in Oracle-compatible mode, consistent with native Oracle behavior.
• Placeholders in name format are automatically converted to ? format when not used in Procedures or Functions.
• Modified the default value of cachePrepStmts to false, aligning it with MySQL JDBC.

Bug fixes

• Fixed the issue where querying Oracle RAW type data via stmt.setBinaryStream returned incomplete data.
• Fixed the error when using setClob with EmptyCLOB() in Oracle-compatible mode.
• Fixed the error when Localdatetime was passed as a timestamp.
• Fixed the field mapping error when using column aliases in a MyBatis environment.
• Fixed the type judgment error after calling getObject() when Clob and Blob are in an inheritance relationship.
• Fixed the error when using SEND PIECE to connect to ODP.
• Fixed the error when specifying the Clob column's class as String in getObject().
• Fixed the error when setting usePipelineAuth=true.
• Fixed the error for the rewriteBatch parameter.
• Fixed the issue where setPort did not take effect in OceanBaseDataSource.
• Fixed the issue where uploading failed due to single quotes in a Clob column.
• Fixed the issue where hints were treated as comments and removed in Oracle-compatible mode.