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 Using 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 "Using commit and rollback" Watch "Using commit and rollback" New topic

Using commit and rollback

Jeff Storey
Ranch Hand

Joined: Apr 07, 2007
Posts: 230
If I am in non-commit mode and I try to commit a database transaction using the commit object, and the commit fails, will all queries in that commit be undone, or do I need to call rollback()? For example, say I want to commit 10 queries, but in the middle of committing them, I lose my database connection. Will the ones that were already committed be permanent changes, or do the changes not get made to the database until all of the queries successfully commit?

Remko Strating
Ranch Hand

Joined: Dec 28, 2006
Posts: 893
Jeff Storey,

When you loose your database connection an exception will be thrown. You can decide after the exception to rollback your transaction. The only problem is that you don't have a connection to a database for rolling back your transaction.

Your DBMS will discover the loss of the connection and will rollback your transaction.

Remko (My website)
SCJP 1.5, SCWCD 1.4, SCDJWS 1.4, SCBCD 1.5, ITIL(Manager), Prince2(Practitioner), Reading/ gaining experience for SCEA,
I agree. Here's the link:
subject: Using commit and rollback
It's not a secret anymore!