Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes PreparedStatement in batched mode gives Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PreparedStatement in batched mode gives Exception" Watch "PreparedStatement in batched mode gives Exception" New topic

PreparedStatement in batched mode gives Exception

Niki Nono
Ranch Hand

Joined: Mar 20, 2005
Posts: 256

I have a problem.
I am running PreparedStatement in batched mode, actually I am using Springs BatchSQLUpdate component.

Now i am creating a batch of about 10000 inserts / updates. However if any single of these inserts / updates fails, it gives exception with DataIntegrityViolation, BadSQLGrammer etc.

I am also maintaining a parallel cache of the values that I am using to bind the preparedstatements.
So for statement 1 in the batch, i know what values are being used.

My question is when the batch update fails, how can we identify which SQL statement, i mean which index in the batch caused the issue?

Please help me as I am stuck and need to build some robust exception handling for PreparedStatement batch loads.


Life called,so here I am.<br />Cheers<br />Niki.:-)
I agree. Here's the link:
subject: PreparedStatement in batched mode gives Exception
Similar Threads
read large CSV file and update the database
Batch update problem in Spring Prepared statement
How can I do batch updates using PreparedStatements rather than Statements?
Performance of update statement versus comparison function
Can you insert into the database without using insert query in a Resultset