JDBC - Oracle - BatchUpdateException.getUpdateCounts() returns blank array

Question

I am trying to execute the batch query using PreparedStatement.executeBatch() and trying to catch any exception occurred in BatchUpdateException. But I am getting a blank array on calling BatchUpdateException.getUpdateCounts().

Below is my code:

int[] updateCounts = null;  
PreparedStatement stmt = null;  
// some logic to set the stmt and create the SQL query
try {  
if (count % 100 == 0)   
    {  
        updateCounts = stmt.executeBatch();  
     }  
} catch (BatchUpdateException bu)  
{   
        updateCounts = bu.getUpdateCounts();  
}

Here I get an empty array of updateCounts when an exception occurs... Why?

NOTE:

BatchUpdateException -

SystemErr R java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("TABLE_ABC"."AMOUNT")

CSV file from where the code reads the data... expecting error in the 3rd record

Asof_Date,Price_Date,Amount
12/15/2015,11/26/2014,-2646.937686
12/15/2015,11/28/2014,5053.611471
12/15/2015,1/22/2015,
12/15/2015,1/23/2015,

By empty array, do you mean an array with length = 0? If so, then it's likely because you didn't actually add anything to the batch, e.g. count is 0. — Andreas
– Andreas, Commented Jan 5, 2016 at 17:21

Jan · Accepted Answer · 2016-01-05 20:31:16Z

1

Well, according to the javadoc, you get one int for the update count of every successful executed statement so an empty array suggests failure on first statement in batch.

Retrieves the update count for each update statement in the batch update that executed successfully before this exception occurred.

As you are able to tell from your Exception, empty values in your CSV cause the failure. So you either allow NULL for that column or check if null and insert 0 instead.

As for the updateCounts: if your batch ran in one transaction (which would make sense) then all inserts would be rolled nack on error - resulting in nothing done.

edited Jan 5, 2016 at 20:31

answered Jan 5, 2016 at 17:22

Jan

13.9k3 gold badges35 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

deejay Over a year ago

According to Javadoc... "a BatchUpdateException provides the update counts for all commands that were executed successfully during the batch update, that is, all commands that were executed before the error occurred", I don't even get that too

Jan Over a year ago

Print your exception with bu.printStackTrace () and post it into your question

Jan Over a year ago

Updated answer to reflect your new info.

deejay Over a year ago

Is there any way to do the batch insert/update and to know the individual query success or failure?

Jan Over a year ago

can you share the code (edit question) for the actual statement? How do you fill in values and so on?

|

Collectives™ on Stack Overflow

JDBC - Oracle - BatchUpdateException.getUpdateCounts() returns blank array

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related