|
Java™
by example!
|
|
|
How do I use transactions with JDBC?
SQL statements can be grouped together in a single statement to ensure the ACID (Atomicity, Consistency, Isolation, Durability) characteristics. By default, each SQL statement is auto-commited. In other words, it is treated as a transaction by itself and will be committed right away. This may not be desirable in cases where all the SQL statements need to be executed or none of them, if one fails. The way this can be done with JDBC is by turning off auto-commit mode before the group of statements and turn auto-commit back on after.
In this example, the first two updates will not affect the database table because of rollback. The last update is explicitely committed.
Typically, you would use commit and rollback in conjunction with Exception handling. eg.
Further Information
Author of answer: Joris Van den Bogaert
Comments to this answer are only viewable by members. Login or become a member!
|
|
|
|
|
In-house 