It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes A failing ExecuteUpdate with AutoCommit=true Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "A failing ExecuteUpdate with AutoCommit=true" Watch "A failing ExecuteUpdate with AutoCommit=true" New topic

A failing ExecuteUpdate with AutoCommit=true

Julian Vicente

Joined: Aug 20, 2003
Posts: 3
If you want to execute only one SQL sentence, it�s necesary to include it in a transacction in order to ensure your database integrity?
I think that, with autoCommint=true, a failing update or insert sentence will never put into the database corrupt data... like if it executes a rollback after failing, but I�m not sure, and I supose that executing each single sentence into a transaction it�s *quite* expensive. Anybody knows something about it?
I agree. Here's the link:
subject: A failing ExecuteUpdate with AutoCommit=true
jQuery in Action, 3rd edition