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

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

Document Feedback

javax.sql.ConnectionPoolDataSource

Last Updated：2026-04-09 07:21:36 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