SET ISOLATION¶
Change the transaction isolation level for the connection.
Syntax¶
SET [ CURRENT ] ISOLATION [ = ]
{
CS | READ COMMITTED
RS | REPEATABLE READ
RESET
}
Description¶
The supported isolation levels in SnappyData are NONE, READ COMMITTED and REPEATABLE READ.
Isolation level NONE indicates no transactional behavior. This is a special constant that indicates that transactions are not supported. The RESET clause corresponds to the NONE isolation level. For more information, see Overview of SnappyData Distributed Transactions.
This statement behaves identically to the JDBC java.sql.Connection.setTransactionIsolation method and commits the current transaction if isolation level has changed.
Example¶
snappy> set ISOLATION READ COMMITTED;
snappy> VALUES CURRENT ISOLATION;
1
----
CS
1 row selected