IntelliJ Java IDE
The moose likes JDBC and the fly likes jdbc driver behaviour Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JDBC
Reply 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
 
 
subject: jdbc driver behaviour
 
Threads others viewed
executeUpdate() Problem???
Looping through PreparedStatement executeBatch for Commit or rollback
Problem in batch update
Is there a way of knowing which record failed in Batch Insert
Batch Insertion
WebSphere development made easy
without the weight of IBM tools
http://www.myeclipseide.com