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.2.3

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

Document Feedback

javax.sql.ConnectionPoolDataSource

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