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 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
Bookmark "A failing ExecuteUpdate with AutoCommit=true" Watch "A failing ExecuteUpdate with AutoCommit=true" New topic
Author

A failing ExecuteUpdate with AutoCommit=true

Julian Vicente
Greenhorn

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?
Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: A failing ExecuteUpdate with AutoCommit=true
 
Similar Threads
how to make jar file for database dependent java application
Post your favorite trick questions
How to decode a String with '& # 39;'?
Extracting sentences from a text file
Drivel