# SET CURRENT ISOLATION statement

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

Issuing this command commits the current transaction, which is consistent with the java.sql.Connection.setTransactionLevel method.

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

#### Syntax

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

    set isolation serializable;

Parent topic: SET statements
Related reference
SET SCHEMA statement