About Implicit and Explicit Transactions

In NuoDB SQL, the default transaction mode is implicit. Each statement starts its own transaction and is automatically committed. 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. Execute 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.