Overview of statement caching
share
OceanBase Connector/J
V2.2.11
Download PDF
Compatibility requirements Overview of OceanBase Connector/J Install and load the OceanBase Connector/J driver Connect Python applications to OceanBase Database 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 source overview Data source characteristics and properties Create and connect to a data source instance Database URLOverview of Java data streams LONG and LONG RAW data types CHAR, VARCHAR, and RAW data types Overview of statement caching Use statement caching Reuse statement objects Use CallableStatements to call stored procedures Handle SQL exceptions Overview of result sets Limits FetchSize refreshRow useCursorFetch Batch processing Failover and load balancing modes LoadBalance strategies LoadBalance strategies configuration methodsSecurity features SQL NetworkCostInfo Troubleshooting Call PL stored proceduresResult set performance Use ARRAY and STRUCT classes Obtain commentsData types supported in Oracle mode Error messages in Oracle mode Supported SQL and PL data types 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
OceanBase, A Highly Scalable Database for Transactional, Analytical, and AI Workloads.
OPE0048694
Resources
© OceanBase 2024. All rights reserved | Cloud Service Agreement | Privacy Policy | Legal | Security