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

OceanBase, A Highly Scalable Database for Transactional, Analytical, and AI Workloads.

Company

About OceanBase Contact Us Partner

Product

OceanBase Cloud OceanBase Enterprise Quick Start Download Pricing

Resources

Docs Blog White Paper Trust Center

Document Feedback

Compatibility requirements

Last Updated：2023-12-14 07:26:05 Updated

OceanBase Connector/J is compatible with only 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 version
V2.4.5	OceanBase Database V1.4.x OceanBase Database V2.0.x OceanBase Database V2.1.x OceanBase Database V2.2.x OceanBase Database V3.1.x OceanBase Database V3.2.x OceanBase Database V4.x.x

Compatibility with Java

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

OceanBase Connector/J version	Compatible Java version
V2.4.5	Java 8 and later

Previous topic

Overview of OceanBase Connector/J

Last

Next topic

Install and load the OceanBase Connector/J driver