| 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: 26138
|
|
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
|
|
 |
|
|
subject: use of commit() and rollback()
|
|
|
0
