Statement caching overview
share
OceanBase Connector/J
V2.2.3
Download PDF
JDBC overview Compatibility requirements Install OceanBase Client 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 Overview of Java data streams LONG and LONG RAW data types LOB data types Overview of LOB data types LOB data API LOB locator API CHAR, VARCHAR, and RAW data types Use CallableStatements to call stored procedures Data source overview Data source characteristics and properties Create and connect to a data source instance Database URL Limits and degradation rules Fetch size Refetch rows Cursor result sets Statement caching overview Use statement cache Reuse statement objects Failover and load balancing modesBatch processing JDBC security features SQL NetworkCostInfo Troubleshooting 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 Supported SQL and PL data types Call PL stored procedures Result set performance Use ARRAY and STRUCT classes Overview of distributed transactions XA components Distributed transaction examples Error messages in Oracle mode Data types supported in Oracle mode
Company
Resources
© OceanBase 2024. All rights reserved | Cloud Service Agreement | Privacy Policy | Legal | Security