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 use of commit() and rollback() Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "use of commit() and rollback()" Watch "use of commit() and rollback()" New topic
Author

use of commit() and rollback()

Joe Busch
Greenhorn

Joined: Jan 07, 2005
Posts: 12
Is it permissible to use commit() and rollback() methods on the Connection object multiple times when setAutoCommit(false) is called initially on the Connection? For example: do some processing affecting several tables, call rollback(), do more processing on several tables, call commit(), and continue using the Connection like this for an unlimited number of transactions?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29249
    
139

Joe,
Yes, you can do as many rollback/commits as you want. This is implied by the following statement in the JavaDoc:
Rollback drops all changes made since the previous commit/rollback and releases any database locks currently held by the Connection.

In other words, a rollback or commit only applies to the statements since the previous one.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: use of commit() and rollback()
 
Similar Threads
Help with implementing user transaction
CMT - Pooled connection availability
Multiple database
A query...plz help!!
How can I rollback when connection close?