This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 and Relational Databases
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 32481
    
214

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.


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
 
Have you checked out Aspose?
 
subject: use of commit() and rollback()
 
It's not a secret anymore!