rollBack()

Rolls back the active transaction associated with the current connection.

Syntax

void rollBack()
 

Parameters

None.

Return values

None.

Exceptions

CwDBConnectionException - If a database error occurs.

Notes

The rollback() method ends the active transaction by rolling back any changes made to the database associated with the current connection. The beginTransaction(), commit() and rollBack() methods together provide management of transaction boundaries for an explicit transaction. This transaction contains SQL queries, which include the SQL statements INSERT, DELETE, or UPDATE, and a stored procedure that includes one of these SQL statements. If the roll back fails, rollback() throws the CwDBTransactionException exception and logs an error.

Important:
Only use rollback() if the connection uses explicit transaction bracketing. If the connection uses implicit transaction bracketing, use of rollback() results in a CwDBTransactionException exception. If you do not end an explicit transaction with rollback() (or commit()) before the connection is released, InterChange Server Express implicitly ends the transaction based on the success of the map. If the map is successful, ICS commits this database transaction. If the map is not successful, ICS implicitly rolls back the database transaction. Regardless of the success of the map, ICS logs a warning.

Before beginning an explicit transaction, you must create a CwDBConnection object with the getDBConnection() method from the BaseDLM class. Make sure that this connection uses explicit transaction bracketing.

See also

beginTransaction(), commit(), getDBConnection(), inTransaction()

Copyright IBM Corp. 2003