9.9 Transactions

• A transaction is a set statements that are committed together, after they all execute flawlessly.
• The following java.sql.Connection method can be used to determine whether statements are to be automatically committed when their executions are completed.

  void setAutoCommit(boolean autoCommit)

• When a non-auto commit mode is on, the following instruction may be used to commit the available transactions.

  void commit()

• In the default setting new connections assume auto-commit modes.
• The following instruction asks to undo all the pending changes made by the connection.

  void rollback()