File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

use of commit() and rollback()

Joe Busch

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

Joined: May 26, 2003
Posts: 33131

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
I agree. Here's the link:
subject: use of commit() and rollback()
It's not a secret anymore!