Database Isolation Level Cross Reference

Database Type Isolation Levels Cross Reference
Database And Tables

Here is a table quick reference of some common database and/or connection types, which use connection level isolation and the equivalent isolation levels. This quick reference may prove useful as a job aid reference, when working with and making decisions about isolation level usage.

Database isolation levels

Data sources

Most restrictive isolation level

More restrictive isolation level

Less restrictive isolation level

Least restrictive isolation level

Amazon SimpleDB

SerializableRepeatable readRead committedRead Uncommitted

dashDB

Repeatable readRead stabilityCursor stabilityUncommitted read

DB2® family of products

Repeatable readRead stability*Cursor stabilityUncommitted read

Informix®

Repeatable readRepeatable readCursor stabilityDirty read

JDBC

SerializableRepeatable readRead committedRead Uncommitted

MariaDB

SerializableRepeatable readRead committedRead Uncommitted

Microsoft SQL Server

SerializableRepeatable readRead committedRead Uncommitted

MySQL

SerializableRepeatable readRead committedRead Uncommitted

ODBC

SerializableRepeatable readRead committedRead Uncommitted

Oracle

SerializableSerializableRead committedRead committed

PostgreSQL

SerializableRepeatable readRead committedRead committed

Sybase

Level 3Level 3Level 1Level 0

Related References