About Implicit and Explicit Transactions

In NuoDB SQL, the default transaction mode is implicit. Each Data Manipulation Language (DML) statement starts its own transaction and is automatically committed or rolled back. If the statement executes successfully then the transaction is committed. If the statement fails then the transaction is rolled back. The benefit of an implicit transaction is that you do not need to specify START TRANSACTION, COMMIT or ROLLBACK statements.

NuoDB SQL also supports explicit transactions. Specify the START TRANSACTION and COMMIT or ROLLBACK statements to use an explicit transaction. The benefit of an explicit transaction is that the transaction is user defined and you can commit or roll back a batch of DML statements as one transaction.

See the following topics: