Transaction Isolation Use the Transaction Isolation option to set the transaction isolation level on the database connection for databases that support it. The isolation level will only be set if it is supported by the database. If it is not supported, RazorSQL will ignore the isolation level. Listed below are the transaction isolation levels supported by RazorSQL in order from least restrictive to most restrictive. WARNING: More restrictive isolation levels can result in row or table level locking for some databses, especially if auto-commit is set to off. This can cause operations to hang when waiting for the lock to be released. 1. Default: Uses the default settings for the database. 2. Read Uncommitted: Allows dirty reads, non-repeatable reads, and phantom reads. 3. Read Committed: Dirty reads are prevented. Non-repeatable reads and phantom reads can occur. 4. Repeatable Read: Dirty reads and non-repeatable reads are prevented. Phantom reads can occur. 5. Serialziable: Dirty reads, non-repeatable reads, and phantom reads are prevented. |
|