SQL-J Language Reference
Page 52 of 121

SET TRANSACTION ISOLATION LEVEL statement

The SET TRANSACTION ISOLATION LEVEL statement allows a user to change the isolation level for the user's connection. Valid levels are SERIALIZABLE and READ COMMITTED.

Issuing this command commits the current transaction, which is consistent with the java.sql.Connection.setTransactionLevel method. To change the isolation without committing the current transaction, see AT ISOLATION clause.

For information about isolation levels, see Locking, Concurrency, and Isolation in the Cloudscape Developer's Guide.

NEW: Support for TRANSACTION_REPEATABLE_READ is new in Version 3.6.

Syntax

SET TRANSACTION ISOLATION LEVEL
{
    READ COMMITTED |
    SERIALIZABLE |
    REPEATABLE READ
}

Example

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE