IBM Data Server Driver for JDBC and SQLJ isolation levels

The IBM Data Server Driver for JDBC and SQLJ supports a number of isolation levels, which correspond to database server isolation levels.

JDBC isolation levels can be set for a unit of work within a JDBC program, using the Connection.setTransactionIsolation method. The default isolation level can be set with the defaultIsolationLevel property.

The following table shows the values of level that you can specify in the Connection.setTransactionIsolation method and their Db2® database server equivalents.

Table 1. Equivalent JDBC and Db2 isolation levels
JDBC value Db2 isolation level
java.sql.Connection.TRANSACTION_SERIALIZABLE Repeatable read
java.sql.Connection.TRANSACTION_REPEATABLE_READ Read stability
java.sql.Connection.TRANSACTION_READ_COMMITTED Cursor stability
java.sql.Connection.TRANSACTION_READ_UNCOMMITTED Uncommitted read

The following table shows the values of level that you can specify in the Connection.setTransactionIsolation method and their IBM Informix® equivalents.

Table 2. Equivalent JDBC and IBM Informix isolation levels
JDBC value IBM Informix isolation level
java.sql.Connection.TRANSACTION_SERIALIZABLE Repeatable read
java.sql.Connection.TRANSACTION_REPEATABLE_READ Repeatable read
java.sql.Connection.TRANSACTION_READ_COMMITTED Committed read
java.sql.Connection.TRANSACTION_READ_UNCOMMITTED Dirty read
com.ibm.db2.jcc.DB2Connection.TRANSACTION_IDS_CURSOR_STABILITY IBM Informix cursor stability
com.ibm.db2.jcc.DB2Connection.TRANSACTION_IDS_LAST_COMMITTED Committed read, last committed