File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc driver behaviour