OceanBase Connector/J

V2.2.6

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
  - Example
- Handle SQL exceptions
- Use CallableStatements to call stored procedures
- 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
- 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
- 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

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

Import packages

Last Updated：2023-07-27 06:37:11 Updated

Before you use the OceanBase JDBC driver, add import statements at the beginning of the application to import the corresponding packages.

The following table describes the import statements.

Import statement	Description
`importjava.sql.*;`	Provides the standard JDBC API.
`importjava.math.*;`	Optional. Provides the BigDecimal and BigInteger classes. If these classes are not required in your application, you can ignore this package.

Previous topic

Install OceanBase Client

Last

Next topic

Create a database connection