OceanBase Connector/J V2.4.8|V2.4.18|OceanBase Connector/J |docs|OceanBase Documentations

Version information

OceanBase Connector/J V2.4.8 supports the LOAD DATA LOCAL INFILE feature and fixes some key bugs.

The LOAD DATA LOCAL INFILE feature is supported. It must be used in combination with OceanBase Database Proxy (ODP) and OceanBase Database. The version of ODP must be V4.2.3 or later, and that of OceanBase Database must be V4.2.2 or later.
Parameter binding interpretation is optimized in the text protocol in Oracle mode. Specifically, "--xxx" will be interpreted as "xxx", rather than a comment.
The following URL parameters are added.

Parameter	Status	Default value	Description
allowLoadLocalInfile (for compatibility with MySQL Connector/J)	New	false	Specifies whether to allow data to be loaded from local files.
encloseParamInParentheses (specific to OceanBase Connector/J)	New	true	Specifies whether to enclose parameter values in parentheses when the text protocol is used to bind parameters in Oracle mode.

This version fixes the following bugs:

Fixed the issue where initialization may be repeatedly performed if you concurrently call the addBatch() method on the same PreparedStatement object. This may cause inconsistency in the amount of table data for the same batch.
Fixed the issue of cursor leaks for PreparedStatement objects.
Fixed the issue where out-of-memory (OOM) exceptions may occur when end-to-end tracing is enabled.
Fixed the issue where the length of input parameters of the TRUNCATE method is not checked.
Fixed the issue where result inconsistency may occur when exceptions exist but are not thrown during cursor fetch.
Fixed the issue where connection establishment fails when the time zone name starts with "GMT" in Oracle mode.
Fixed the issue where the precision is not aligned when the getString() method is called on data of a datetime or time type with a precision specified in MySQL mode.
Fixed the issue where the No output result error is returned during PL execution in MySQL mode.
Fixed the issue where the execution result of the getBytes() method is incorrect in the PreparedStatement protocol in MySQL mode.
Fixed the issue where the execution of REF_CURSOR may hang when cursors are enabled on the server.
Fixed the issue where an ArrayIndexOutOfBoundsException occurs if the value of the defaultFetchSize parameter is less than 10 when both the PreparedStatement and PrepareExecute protocols are enabled in Oracle mode.