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 ServiceOceanBase DataPilot

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 ServiceOceanBase DataPilot
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase Connector/J

V2.2.3
  • What is OceanBase Connector J?
    • JDBC overview
    • Compatibility requirements
  • Instructions
    • Install OceanBase Client
    • Basic operations
      • Import packages
      • Create a database connection
      • Create a Statement object
      • Run queries and retrieve ResultSet objects
      • Process a ResultSet object
      • Close ResultSet and Statement objects
      • Modify a database
      • Commit changes
      • Close a database connection
    • Handle SQL exceptions
    • Java data streams
      • Overview of Java data streams
      • LONG and LONG RAW data types
      • LOB data types
    • Use LOBs
      • Overview of LOB data types
      • LOB data API
      • LOB locator API
      • CHAR, VARCHAR, and RAW data types
    • Use CallableStatements to call stored procedures
    • Data sources and URL
      • Data source overview
      • Data source characteristics and properties
      • Create and connect to a data source instance
      • Database URL
    • Result set
      • Limits and degradation rules
      • Fetch size
      • Refetch rows
      • Cursor result sets
    • Statement caching
      • Statement caching overview
      • Use statement cache
      • Reuse statement objects
    • Failover and load balancing modes
    • Batch processing
    • JDBC security features
    • SQL NetworkCostInfo
    • Troubleshooting
    • Common APIs
      • 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
    • Reference
      • Supported SQL and PL data types
  • Features specific to the Oracle mode
    • Call PL stored procedures
    • Result set performance
    • Use ARRAY and STRUCT classes
    • Distributed transactions
      • Overview of distributed transactions
      • XA components
      • Distributed transaction examples
    • Error messages in Oracle mode
    • Data types supported in Oracle mode
  • Release Notes
    • V2.2
      • OceanBase Connector/J V2.2.11
      • OceanBase Connector/J V2.2.10
      • OceanBase Connector/J V2.2.3
      • OceanBase Connector/J V2.2.0

Download PDF

Document Feedback
  1. Documentation Center
  3. OceanBase Connector/J
  5. V2.2.3

OceanBase Connector/J V2.2.3

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

Version information
Overview
Feature enhancements
Bug fixes

Version information

  • Release date: July 21, 2021
  • Version: V2.2.3

Overview

OceanBase Connector/J V2.2.3 introduces features such as direct connection to ODP, JDBC Socks Proxy, recording SQL network transmission time, enriches URL options, and fixes customer issues. It is ready for routine business use.

Feature enhancements

  • Added direct connection to ODP, supporting querying and modifying ODP configurations.
  • Added JDBC Socks Proxy functionality.
  • Added URL options: useUnicode, prepStmtCacheSqlLimit, useLocalTransactionState, and useLocalSessionState.
  • Added the networkStatistics feature to record SQL network transmission time.

Bug fixes

  • Fixed an issue where a NPE occurred in the prepareCall of a stored procedure due to missing URL database information in Oracle-compatible mode.
  • Fixed an issue where a float column could not be converted to a BigDecimal in Oracle-compatible mode.
  • Fixed an issue where type values in OceanBase Database's Oracle-compatible mode were inconsistent with Oracle.
  • Fixed an issue where getWarnings returned NULL in Oracle-compatible mode.
  • Fixed an issue where a checksum error occurred under JDBC GB2312 encoding.

Notice

When characterEncoding=true is set in the current version and the tenant's character set encoding is GBK, data queries and inserts may result in garbled characters.

Previous topic

OceanBase Connector/J V2.2.10
Last

Next topic

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