OceanBase Connector/J V2.2.11

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.

Feature enhancements

• OceanBase Connector/J supports the ArrayBinding feature in Oracle mode. In the PreparedStatement protocol, parameters are bound as arrays to realize multiple interactions between the server and client in a single batch, reducing the interaction cost.
• 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 remarks 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 establishment efficiency.
• The XID-involved complex queries can be locally executed with higher performance. Corresponding options are provided for better control.

Bug fixes

• Fixed the issue where, 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 the issue where closing a statement by calling the Statement.close() method after createStatement() and excuteQuery() failures (with useServerPrepStmts=true) results in the error that open cursors on the OBServer node exceed the maximum number allowed, because the COM_CLOSE action is not sent to the OBServer node.
• Fixed the issue where the JDBC methods DatabaseMetaData.storesUpperCaseIdentifiers() and DatabaseMetaData.storesLowerCaseIdentifiers() return conflicting values in Oracle mode.