Open topic with navigation
You can change default transaction behavior as follows:
START TRANSACTION READ ONLY(see
START TRANSACTION). This setting is in effect for only this transaction. This starts an explicit transaction (see About Implicit and Explicit Transactions ) which will suspend the
SET AUTOCOMMIT OFF(See
SET). When autocommit behavior is disabled and there is no
START TRANSACTIONstatement, then execution of a statement implicitly starts a transaction. This transaction is open until you specify a
ROLLBACK). Autocommit remains disabled unless there is a
SET AUTOCOMMIT ONstatement or the connection closes.
SET ISOLATION LEVEL. The new setting is in effect with the start of the next transaction and stays in effect unless the level is reset with another
SETcommand or the connection closes. See Supported Transaction Isolation Levels for a description of each transaction isolation level that NuoDB supports.
nuosql test@localhost --user dba --password dba --connection-property isolation=read_committed
When NuoDB executes a statement and there is not already an active transaction then NuoDB starts a transaction and applies the default transaction behaviors. The default transaction behaviors might be the original defaults or defaults that you have set or a mixture of both. An exception to this behavior is the
START TRANSACTION statement, which lets you override default transaction behavior. See About Implicit and Explicit Transactions