5. Working with a Database : How You Can Manage Transactions
 
Share this page                  
How You Can Manage Transactions
A transaction is one or more database statements processed as a single, indivisible unit. A transaction begins with the first database statement executed after the application is started or after a previous commit or rollback statement. By default, the transaction continues until one of the following occurs:
An explicit commit or rollback statement occurs
A deadlock or log full error occurs
The application stops
All locks taken during the transaction are held until the transaction is completed, and any changes made to a database by the transaction are not visible to other users until the transaction is committed.