The moose likes JDBC and Relational Databases and the fly likes Rollback when any error occurrs Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Rollback when any error occurrs" Watch "Rollback when any error occurrs" New topic

Rollback when any error occurrs

amit sharma
Ranch Hand

Joined: Jul 19, 2006
Posts: 129
I have transaction of statements .I am settings AutoCommit to false.But when an error occurs for data truncation in 2nd statement ,it not rollback the changes done by other statement .My need is whenever any error occurs ,the whole batch should be rllback.
I agree. Here's the link:
subject: Rollback when any error occurrs
It's not a secret anymore!