Search within JDBC and Relational Databases
Register / Login
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
JDBC and Relational Databases
PreparedStatement in batched mode gives Exception
posted 12 years ago
Number of slices to send:
Optional 'thank-you' note:
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.:-)
Don't get me started about those stupid
Boost this thread!
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
Batch update problem in Spring Prepared statement
read large CSV file and update the database