OceanBase logo

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

Resources

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

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

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 CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase 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

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

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

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
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogLive DemosTraining & Certification
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Connector/J
  3. V2.2.3
iconOceanBase Connector/J
V 2.2.3
  • V 2.4.17
  • V 2.4.16
  • V 2.4.15
  • V 2.4.14
  • V 2.4.5
  • V 2.4.4
  • V 2.4.3
  • V 2.4.2
  • V 2.4.1
  • V 2.4.0
  • V 2.2.11
  • V 2.2.10
  • V 2.2.7
  • V 2.2.6
  • V 2.2.3
  • V 2.2.0

Batch processing

Last Updated:2026-04-09 07:36:39  Updated
share
What is on this page
Batch processing in MySQL mode
Example

folded

share

Multiple UPDATE or INSERT statements can be grouped into a batch, and the entire batch is sent to the database for processing. This process reduces the number of round trips to the database and improves the application performance.

The JDBC driver uses PrepareStatement and Statements on the server as standards for communicating with the database for batch processing and manages the standards by setting the allowMultiQueries and rewriteBatchedStatements parameters. If allowMultiQueries or rewriteBatchedStatements is set to true, the JDBC driver uses only the text protocol. PrepareStatement(parameter replacement) is handled by the driver on the client.

In an INSERT query, rewriteBatchedStatements is used to rewrite batchedStatement for execution in single executeQuery. If you set this parameter set to true, useServerPrepStmts is set to false. When allowMultiQueries is set to true, multi-value queries are allowed.

The JDBC driver provides different batch processing settings in Oracle and MySQL modes. Batch processing in Oracle mode

PrepareStatement

useServerPrepStmts rewriteBatchedStatements allowMultiQueries INSERT operation UPDATE operation
true true true The prepared SQL string changes to the VALUES(),(),()...format. The prepared SQL string is in the normal format, and then parameters are set with multiple EXECUTE operations.
true true false The prepared SQL string changes to the VALUES(),(),()...format. The prepared SQL string is in the normal format, and then parameters are set with multiple EXECUTE operations.
true false true The prepared SQL string is in the normal format, and then parameters are set with multiple EXECUTE operations. The prepared SQL string is in the normal format, and then parameters are set with multiple EXECUTE operations.
true false false The prepared SQL string is in the normal format, and then parameters are set with multiple EXECUTE operations. The prepared SQL string is in the normal format, and then parameters are set with multiple EXECUTE operations.
false true true Multiple statements are combined into a complete string in the VALUES(),(),()... format. Multiple statements are combined into a complete string in the VALUES(),(),()... format.
false true false Multiple statements are combined into a complete string in the VALUES(),(),()... format. Multiple UPDATE statements are executed.
false false true Multiple INSERT statements are executed. Multiple UPDATE statements are executed.
false false false Multiple INSERT statements are executed. Multiple UPDATE statements are executed.

Statement

useServerPrepStmts rewriteBatchedStatements allowMultiQueries INSERT operation UPDATE operation
true true true The SQL string changes to the VALUES(),(),()... format. The SQL string changes to the VALUES(),(),()... format.
true true false The SQL statements are executed one by one. The SQL statements are executed one by one.
true false true The SQL string changes to the VALUES(),(),()... format. The SQL string changes to the VALUES(),(),()... format.
true false false The INSERT statements are executed one by one. The UPDATE statements are executed one by one.
false true true The SQL string changes to the VALUES(),(),()... format. The SQL string changes to the VALUES(),(),()... format.
false true false The SQL statements are executed one by one. The SQL statements are executed one by one.
false false true The SQL string changes to the VALUES(),(),()... format. The SQL string changes to the VALUES(),(),()... format.
false false false The INSERT statements are executed one by one. The UPDATE statements are executed one by one.

Batch processing in MySQL mode

PrepareStatement

useServerPrepStmts rewriteBatchedStatements allowMultiQueries INSERT operation UPDATE operation
true true true The SQL string changes to the VALUES(),(),()... format. The SQL strings prepared one by one are in the normal format, and then parameters are set with multiple EXECUTE operations.
true true false The SQL string changes to the VALUES(),(),()... format. The SQL strings prepared one by one are in the normal format, and then parameters are set with multiple EXECUTE operations.
true false true The prepared SQL string is in the normal format, and then parameters are set with multiple EXECUTE operations. The prepared SQL string is in the normal format, and then parameters are set with multiple EXECUTE operations.
true false false The prepared SQL string is in the normal format, and then parameters are set with multiple EXECUTE operations. The prepared SQL string is in the normal format, and then parameters are set with multiple EXECUTE operations.
false true true Multiple statements are combined into a complete string in the VALUES(),(),()... format. Multiple statements are combined into a complete string in the VALUES(),(),()... format.
false true false Multiple statements are combined into a complete string in the VALUES(),(),()... format. Multiple UPDATE statements are executed.
false false true Multiple INSERT statements are executed. Multiple UPDATE statements are executed.
false false false Multiple INSERT statements are executed. Multiple UPDATE statements are executed.

Statement

useServerPrepStmts rewriteBatchedStatements allowMultiQueries INSERT operation UPDATE operation
true true true The SQL string changes to the VALUES(),(),()... format. The SQL string changes to the VALUES(),(),()... format.
true true false The SQL statements are executed one by one. The SQL statements are executed one by one.
true false true The SQL string changes to the VALUES(),(),()... format. The SQL string changes to the VALUES(),(),()... format.
true false false The INSERT statements are executed one by one. The UPDATE statements are executed one by one.
false true true The SQL string changes to the VALUES(),(),()... format. The SQL string changes to the VALUES(),(),()... format.
false true false The SQL statements are executed one by one. The SQL statements are executed one by one.
false false true The SQL string changes to the VALUES(),(),()... format. The SQL string changes to the VALUES(),(),()... format.
false false false The INSERT statements are executed one by one. The UPDATE statements are executed one by one.

Example

public void test_execute_batch() {
    Connection conn = null;
    try {
        for (int q = 0; q < 2; q++) {
            for (int w = 0; w < 2; w++) {
                for (int e = 0; e < 2; e++) {


                    /**
                     *  useServerPrepStmts = true / false
                     *  rewriteBatchedStatements = true / false
                     *  allowMultiQueries = true / false
                     */
                    boolean uSPS = q == 0 ? false : true;
                    String rBS = w == 0 ? "false" : "true";
                    String aMQ = e == 0 ? "false" : "true";

                    String other_condition = "&rewriteBatchedStatements=" + rBS
                            + "&allowMultiQueries=" + aMQ;
                    conn = ConnectionUtils.getDefObOracleConnection(uSPS, true, other_condition);
                    Statement statement = conn.createStatement();

                    try {
                        statement.execute("DROP TABLE test_batch_t");
                    } catch (SQLException exp) {
                        //e.printStackTrace();
                    }

                    String sql = "create table test_batch_t(id int primary key, c1 varchar2(10))";
                    statement.execute(sql);

                    PreparedStatement ps = conn
                            .prepareStatement("insert into test_batch_t(id, c1) values (?, ?)");

                    for (int j = 0; j < 10; j++) {
                        ps.setInt(1, j);
                        ps.setString(2, j + "_test");
                        ps.addBatch();
                    }
                    ps.executeBatch();

                    ps = conn.prepareStatement("update test_batch_t set id = ? where c1 = ?");

                    for (int j = 0; j < 10; j++) {
                        ps.setInt(1, j);
                        ps.setString(2, j + "_test");
                        ps.addBatch();
                    }
                    ps.executeBatch();
                }
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
    }


}

Previous topic

Failover and load balancing modes
Last

Next topic

JDBC security features
Next
What is on this page
Batch processing in MySQL mode
Example