Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

OceanBase Connector/J

V2.4.2

What is OceanBase Connector J?
- Compatibility requirements
- Overview of OceanBase Connector/J
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
  - Example
- Data sources and URL
  - Data source overview
  - Data source characteristics and properties
  - Create and connect to a data source instance
  - 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 API
  - CHAR, VARCHAR, and RAW data types
- Statement caching
  - Overview of statement caching
  - Use statement caching
  - Reuse statement objects
- Use CallableStatements to call stored procedures
- Handle SQL exceptions
- Result set
  - Overview of result sets
  - Limits
  - FetchSize
  - refreshRow
  - useCursorFetch
- Batch processing
- Failover and Load-Balancing
  - Failover and load balancing modes
  - LoadBalance strategies
  - LoadBalance strategies configuration methods
- Security features
- SQL NetworkCostInfo
- 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
  - 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
- Supported SQL and PL data types
- Common APIs
  - Overview of 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

Download PDF

Compatibility requirements|V2.4.2|OceanBase Connector/J | docs|Distributed Database

Document Feedback

Compatibility requirements

Last Updated：2026-04-09 07:21:36 Updated

OceanBase Connector/J is compatible with specific OceanBase Database and Java versions.

Compatibility with OceanBase Database

The following table describes the compatibility between OceanBase Connector/J and OceanBase Database.

OceanBase Connector/J version	Compatible OceanBase Database versions
V2.4.2	OceanBase V1.4.x OceanBase V2.0.x OceanBase V2.1.x OceanBase V2.2.x OceanBase V3.1.x OceanBase V3.2.x

Compatibility with Java

The following table describes the compatibility between OceanBase Connector/J and Java.

OceanBase Connector/J version	Compatible Java versions
V2.4.2	Java 11 Java 8

Next topic

Overview of OceanBase Connector/J