SET ISOLATION

Change the transaction isolation level for the connection.

Syntax

SET [ CURRENT ] ISOLATION [ = ]
{ 
UR | DIRTY READ | READ UNCOMMITTED 
CS | READ COMMITTED
RS | REPEATABLE READ
RESET
}

Description

The supported isolation levels in GemFire XD are NONE, READ COMMITTED, READ UNCOMMITTED, and REPEATABLE READ. The READ UNCOMMITTED level is implicitly upgraded to READ COMMITTED.

Isolation level NONE indicates no transactional behavior. The RESET clause corresponds to the NONE isolation level.

Understanding the Data Consistency Model and Using Distributed Transactions in Your Applications provide details about non-transactional and transactional behavior in GemFire XD.

This statement behaves identically to the JDBC java.sql.Connection.setTransactionIsolation method and commits the current transaction if isolation level has changed.

Example

gfxd(PEERCLIENT)> set ISOLATION READ COMMITTED;
0 rows inserted/updated/deleted
gfxd(PEERCLIENT)> VALUES CURRENT ISOLATION;
1
----
CS

1 row selected