aspose file tools*
The moose likes JDBC and the fly likes jdbc driver behaviour Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc driver behaviour" Watch "jdbc driver behaviour" New topic
Author

jdbc driver behaviour

jacq carballo
Ranch Hand

Joined: Feb 10, 2002
Posts: 42
Hello all!
Database: SQL Server 7.0
method used: java.sql.Statement.executeBatch()
When one of the commands executed has an error (SQLException), the executeBatch command stops at the last executed record. Is there an API whose executeBatch() method simply reports the error and continues with the rest of the unexecuted batch commands?
I know that the executeBatch() method behaves according to the driver as stated in the javadocs. Just want to know if there is another API that would do a batch update on all records, except the one with an error.
TIA
jacq carballo
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: jdbc driver behaviour