Version information
Release date: September 13, 2022
Version: V2.2.11
Overview
OceanBase Connector/J V2.2.11 supports the ArrayBinding, CallableStatement set by name, and setRemarksReportingLoadBalance features, and is more compatible with MySQL and Oracle. This version applies to general businesses.
Enhanced features
- OceanBase Connector/J supports the ArrayBinding feature in Oracle mode. In the PreparedStatement and PrepareExecute protocols, parameters are bound as arrays for batch execution to reduce the interaction cost between the server and the client.
- OceanBase Connector/J supports the CallableStatement set by name feature in Oracle mode. You can assign values based on defined variable names.
- OceanBase Connector/J supports the setRemarksReporting feature in Oracle mode. You can obtain remark information by using metadata class methods such as getColumns.
- Compatibility with MySQL, such as the compatibility with the setObject() method and PreparedStatement caching, is improved in MySQL mode.
- The getServerTZTablesImported query method is optimized to improve connection creation efficiency.
- The XID-involved complex queries can be locally executed with higher performance. Corresponding options are provided for better control.
Bug fixes
- Fixed an issue that when both the PreparedStatement and PrepareExecute protocols are enabled, a SELECT statement that contains UNION ALL returns only one row of data and does not send the fetch request.
- Fixed an issue that when the
useServerPrepStmtsparameter is set totrueand the execution of thecreateStatement()->excuteQuery()statement fails, if you do not send the COM_CLOSE method to the server when you call the s.close() method, an error will be returned, indicating that the open cursors on the OBServer node exceed the maximum number allowed. - Fixed an issue that JDBC DatabaseMetaData.storesUpperCaseIdentifiers() and storesLowerCaseIdentifiers() return conflicting values in Oracle mode.