My Oracle Support Banner

How to Return the Row Count of DML Statements Executed in a JDBC batch (Doc ID 472285.1)

Last updated on AUGUST 09, 2023

Applies to:

JDBC - Version 11.2.0.1.0 to 21.5 [Release 11.2 to 21]
Information in this document applies to any platform.
Information in this document applies to any platform.
Retested and updated using JDBC 21c

Goal

How to return the row count of DML statements executed in a JDBC batch.

The article explores the Oracle driver  implementation of the Standard JDBC batching. The code examples show what can be done and also highlight the limitations of each approach.

The examples are based on the Oracle JDBC developer's guide and rely on a EMP2 table as follows:

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
  Summary:
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.