Call PL stored procedures|V2.4.5|OceanBase Connector/J| docs|Distributed Database

OceanBase Connector/J

V2.4.5

What is OceanBase Connector J?
- Overview of OceanBase Connector/J
- Compatibility requirements
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
  - Examples
- Data sources and URL
  - Data source overview
  - 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 interface
  - CHAR, VARCHAR, and RAW data types
- Statement caching
  - Overview of statement caching
  - Use statement caching
  - Reuse statement objects
- Call a stored procedure
- Handle SQL exceptions
- Result set
  - Overview of result sets
  - Limitations
  - FetchSize
  - refreshRow
  - useCursorFetch
- Batch processing
- Failover and Load-Balancing
  - Failover and load balancing modes
  - LoadBalance strategies
  - Load balancing strategy configuration methods
- Rich client
- Logging
- Network overheads
- Show Trace
- Security features
- 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
  - Scrollability of a result set
  - Use ARRAY and STRUCT classes
  - Distributed transactions
    - Overview
    - XA components
    - Distributed transaction examples
  - Obtain comments
  - Data types supported in Oracle mode
  - Error messages in Oracle mode
- Supported SQL and PL data types
- Common APIs
  - Overview
  - 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
  - com.oceanbase.jdbc.ObPrepareStatement
Release Notes
- V2.4
  - OceanBase Connector/J V2.4.5
  - OceanBase Connector/J V2.4.4
  - OceanBase Connector/J V2.4.3
  - OceanBase Connector/J V2.4.2
  - OceanBase Connector/J V2.4.1
  - OceanBase Connector/J V2.4.0
- V2.2
  - OceanBase Connector/J V2.2.11
  - OceanBase Connector/J V2.2.10
  - OceanBase Connector/J V2.2.7
  - OceanBase Connector/J V2.2.6
  - OceanBase Connector/J V2.2.3
  - OceanBase Connector/J V2.2.0

Download PDF