A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
PreparedStatement in batched mode gives Exception
Joined: Mar 20, 2005
Jun 04, 2009 01:15:51
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: PreparedStatement in batched mode gives Exception
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
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015