Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI. Explore ->

Start on Cloud

OceanBase

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

Product Overview

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

Select Version

OceanBase Connector/J

OceanBase Connector/J is a driver that implements the JDBC API to provide connections to OceanBase Database for Java-based applications. OceanBase Connector/J is a JDBC Type 4 driver that can be connected to a database engine by using local protocols. OBServers support OceanBase Connector/J and are fully compatible with MySQL Connector Java, which is the native JDBC driver for MySQL. OceanBase Connector/J is fully compatible with MySQL JDBC. OceanBase Connector/J automatically determines whether OceanBase Database runs in MySQL or Oracle mode and supports both modes at the protocol layer.

Download

Build a Business System

Install OceanBase Connector/J

Use OceanBase Connector/J

1
Install OceanBase Connector/J
You can use a JAR package to install OceanBase Connector/J.
For more information, see "Install and load the OceanBase Connector/J driver".

Dive Deep into OceanBase Connector/J

References of OceanBase Connector/J
Learn more about the general API operations of OceanBase Connector/J
Documents

OceanBase Connector/J

V2.4.18

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.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