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