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

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-08-30 08:36:44 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