OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase Connector/J

V2.4.19
  • What is OceanBase Connector J?
    • Overview of OceanBase Connector/J
    • Compatibility requirements
  • Install Driver
    • Install and load OceanBase Connector/J
  • Instructions
    • Quick start
      • Import packages
      • Establish a database connection
      • Create a Statement object
      • Run queries and retrieve ResultSet objects
      • Process ResultSet objects
      • Close ResultSet and Statement objects
      • Manage tables and data
      • Commit changes
      • Close a database connection
      • Examples
    • Data sources and URL
      • Data source overview
      • Database URL
      • clientInfoProvider
    • Java data streams
      • Overview of Java data streams
      • LONG and LONG RAW data types
      • Use LOBs
        • Overview of LOB data types
        • LOB data interface
        • LOB locator interface
      • CHAR, VARCHAR, and RAW data types
    • Statement caching
      • Overview of statement caching
      • Use statement caching
      • Reuse statement objects
    • Call a stored procedure
    • Handle SQL exceptions
    • Result set
      • Overview of result sets
      • Limitations
      • FetchSize
      • refreshRow
      • useCursorFetch
    • Batch processing
    • Failover and Load-Balancing
      • Failover and load balancing modes
      • LoadBalance strategies
      • Load balancing strategy configuration methods
      • Replication mode
    • Rich client
    • Logging
    • Network overheads
    • Show Trace
    • Security features
    • Troubleshooting
  • Reference
    • Features specific to the Oracle mode
      • Binary Protocol (Prepared Statements)
        • COM_STMT_PREPARE_EXECUTE
        • COM_STMT_SEND_PIECE_DATA
      • Call PL stored procedures
      • Scrollability of a result set
      • Use ARRAY and STRUCT classes
      • Distributed transactions
        • Overview
        • XA components
        • Distributed transaction examples
      • Obtain remarks
      • Data types supported in Oracle mode
      • Error messages in Oracle mode
    • Supported SQL and PL data types
    • Common APIs
      • Overview
      • java.sql.Connection
      • java.sql.CallableStatement
      • java.sql.DatabaseMetaData
      • java.sql.Driver
      • java.sql.PreparedStatement
      • java.sql.ParameterMetaData
      • java.sql.ResultSet
      • java.sql.ResultSetMetaData
      • java.sql.Statement
      • javax.sql.ConnectionPoolDataSource
      • javax.naming.Context
      • javax.sql.PooledConnection
      • com.oceanbase.jdbc.ObPrepareStatement
    • Behavior differences between JDBC strict compatibility mode and non-strict compatibility mode
  • Release Notes
    • V2.4
      • OceanBase Connector/J V2.4.19
      • OceanBase Connector/J V2.4.18
      • OceanBase Connector/J V2.4.17
      • OceanBase Connector/J V2.4.16
      • OceanBase Connector/J V2.4.15
      • OceanBase Connector/J V2.4.14
      • OceanBase Connector/J V2.4.13
      • OceanBase Connector/J V2.4.12
      • OceanBase Connector/J V2.4.11
      • OceanBase Connector/J V2.4.8
      • OceanBase Connector/J V2.4.5
      • OceanBase Connector/J V2.4.4
      • OceanBase Connector/J V2.4.3
      • OceanBase Connector/J V2.4.2
      • OceanBase Connector/J V2.4.1
      • OceanBase Connector/J V2.4.0
    • V2.2
      • OceanBase Connector/J V2.2.11
      • OceanBase Connector/J V2.2.10
      • OceanBase Connector/J V2.2.7
      • OceanBase Connector/J V2.2.6
      • OceanBase Connector/J V2.2.3
      • OceanBase Connector/J V2.2.0

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase Connector/J
  3. V2.4.19

OceanBase Connector/J V2.4.4

Last Updated:2026-09-17 02:32:36

Version information
Overview
Feature enhancements
Bug fixes

Version information

  • Release date: July 10, 2023
  • Version: V2.4.4

Overview

OceanBase Connector/J V2.4.4 provides enhanced log diagnostic capabilities and fixes bugs of earlier versions. The version is recommended for general businesses.

Feature enhancements

  • The JDBC logging feature is enhanced. I/O logs are distinguished from time consumption logs. JDBC diagnostic capabilities are improved.
  • The getIndex(name) method is optimized.
  • The internal resource release mechanism is optimized to resolve issues where the number of cursors reaches the upper limit.
  • The setFixedCHAR() method is supported. For more information, see com.oceanbase.jdbc.ObPrepareStatement.

Bug fixes

  • Fixed the issue where the values obtained by the getScale() and getColumnDisplaySize() methods are inconsistent with those in native Oracle when the precision of NUMBER values is negative.
  • Fixed the issue where the return result contains garbled characters when procedures in system tables are queried.
  • Fixed the issue where floating-point numbers in composite data types are forcibly converted into integers.
  • Fixed the issue of null pointers when the logging feature of OceanBase Connector/J is enabled.
  • Fixed the issue where the error "Flag '0'" is returned when you query data of the INTERVAL DAY TO SECOND type in Oracle mode.
  • Fixed the issue where the error "java.lang.StringIndexOutOfBoundsException" is returned when the ON DUPLICATE KEY UPDATE statement is used to insert data and the VALUES function is used after ON DUPLICATE KEY UPDATE.
  • Fixed the issue where an error is returned when the getString(), getDouble(), getFloat(), or getObject() method is used to obtain invalid values INF, -INF, and NaN of the BINARY_FLOAT or BINARY_DOUBLE data type in Oracle mode.
  • Fixed the issue where the error ArrayIndexOutOfBoundsException is returned when a DML statement containing the RETURNING ... INTO ... clause is sent when both the PreparedStatement and PrepareExecute protocols are enabled.
  • Fixed the issue where the DatabaseMetaData.getTables() method returns an error when the table name contains backticks (`). MySQL does not return an error in such a case.
  • Fixed the issue where values of the DOUBLE type obtained by the getBigDecimal() method are inconsistent with those in native MySQL when the PreparedStatement protocol is enabled.
  • Fixed the issue where the getObject(1, OffsetTime.class) method returns an error when serverTimezone=Asia/Shanghai is set.

Previous topic

OceanBase Connector/J V2.4.5
Last

Next topic

OceanBase Connector/J V2.4.3
Next
on this page
Version information
Overview
Feature enhancements
Bug fixes