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

javax.sql.ConnectionPoolDataSource

Last Updated：2023-07-27 06:42:08 Updated

javax.sql.ConnectionPoolDataSource is the connection pool interface of data sources.

Description

A factory for PooledConnection objects. Objects that implement this interface are typically registered with a naming service that is based on Java Naming and Directory Interface™ (JNDI).

Methods

Method	Return type	JDBC 4 supported in Oracle mode	JDBC 4 supported in MySQL mode
getPooledConnection()	PooledConnection	Yes	Yes
getPooledConnection(String user,String password)	PooledConnection	Yes	Yes

Previous topic

java.sql.Statement

Last

Next topic

javax.naming.Context