Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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
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