Version information
Release date: September 13, 2022
Version: V2.2.11
Overview
OceanBase Connector/J V2.2.11 introduces new features including ArrayBinding, CallableStatement set by name, and setRemarksReportingLoadBalance in Oracle mode, enhancing compatibility with MySQL and Oracle databases. It is suitable for routine business use.
Feature enhancements
- Added ArrayBinding feature in Oracle mode. When used under the PS/II protocol, it binds parameters as arrays to achieve multiple batch executions in one go, reducing data interaction costs between the server and client.
- Added support for the CallableStatement set by name feature in Oracle mode, allowing values to be assigned based on predefined variable names.
- Added support for the setRemarksReporting feature in Oracle mode. Remarks information can be obtained through metadata methods such as getColumns.
- Enhanced MySQL compatibility in MySQL mode, such as aligning behaviors like setObject and PreparedStatement caching.
- Improved the getServerTZTablesImported query method to enhance connection establishment efficiency.
- Optimized performance for XID complex type queries, added localized processing functionality, and provided corresponding options for control.
Bug fixes
- Fixed an issue where a SELECT statement with UNION ALL returned only one row of data and did not send a fetch request under the PS/II protocol.
- Fixed an issue where, when useServerPrepStmts=true, if createStatement()->excuteQuery() failed, the case statement would call s.close() without actually closing it, triggering an error due to the observer PS cursor exceeding limits.
- Fixed an issue where the return values of JDBC DatabaseMetaData.storesUpperCaseIdentifiers() and storesLowerCaseIdentifiers() conflicted in Oracle mode.