JDBC Programmer Reference › Distributed Transactions › Using SQL Transaction and Session Commands › COMMIT and ROLLBACK

COMMIT and ROLLBACK

COMMIT and ROLLBACK are ANSI standard statements used to control transaction boundaries:

• COMMIT [CONTINUE|RELEASE]
• ROLLBACK [RELEASE]
• RELEASE

If an application executes these statements while the connection is associated with the local transaction, the driver sends them to CA IDMS and attempts to determine the state of the transaction and SQL session. Applications should use the equivalent JDBC Connection commit and rollback methods instead of executing these commands.

If an application executes these statements while the connection is associated with a global transaction, the JDBC driver returns an error. The application or transaction manager must use the commit and rollback methods defined by the Java Transaction Architecture (JTA) to complete the transaction.