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 MARCH 26, 2021

Applies to:

JDBC - Version 10.2.0.1 to 11.1.0.6 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Information in this document applies to any platform.

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 as well as the Oracle style JDBC batching. Three 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.