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.5
  • What is OceanBase Connector J?
    • Overview of OceanBase Connector/J
    • Compatibility requirements
  • Install Driver
    • Install and load the OceanBase Connector/J driver
  • Instructions
    • Quick start
      • Import packages
      • Create 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
    • 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
    • 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 comments
      • 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
  • Release Notes
    • V2.4
      • 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.5

OceanBase Connector/J V2.4.1

Last Updated:2026-09-04 08:24:26

Version information
Overview
Enhanced features
Bug fixes

Version information

  • Release date: December 15, 2022

  • Version: V2.4.1

Overview

OceanBase Connector/J V2.4.1 integrates the rich client feature in V2.3.0 and fixes many issues related to compatibility with MySQL. This version applies to general businesses.

Enhanced features

  • The rich client feature is integrated to provide the routing logic of ODP in the driver. In this way, business requests are calculated in the driver and directly routed to the target OBServer node. As no load balancer is required, the access links are short.
  • The following options are provided: obProxySocket, clobberStreamingResults, maxRows, zeroDateTimeBehavior, allowNanAndInf, defaultConnectionAttributesBanList, and enableOb20Checksum.
  • A Java virtual machine (JVM) parameter is provided for users to export a header based on the OB2.0 protocol on their OS console.
  • Verification based on the OB2.0 protocol is supported. Users can specify whether to enable the verification by using a switch parameter.

Bug fixes

  • Fixed some MySQL compatibility issues.
  • Fixed an issue that the setDate() function triggers an exception when binary write is enabled.
  • Fixed an issue that if you set a value of the STRING type in an ARRAY or STRUCT object to another object type, the value is forcibly converted and an error is reported.
  • Fixed an issue that if you do not specify schema in a URL in Oracle mode, the getSchema() method throws a null pointer exception after the connection is established.
  • Fixed an issue that an error occurs when you call the getObject() function to obtain data.

Notice

OceanBase Connector/J of this version uses some DatabaseMetaData methods, such as getProcedures, getTables, getSchemas, getColumns, getFunctions, getTablePrivileges, getPrimaryKeys, getBestRowldentifier, getColumnPrivileges, and keysQuery, to return a result set. A call to close will cause infinite recursion.

Previous topic

OceanBase Connector/J V2.4.2
Last

Next topic

OceanBase Connector/J V2.4.0
Next
on this page
Version information
Overview
Enhanced features
Bug fixes