Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

use of commit() and rollback()

 
Joe Busch
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34382
346
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic