Isolation Levels
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
The DB2 driver supports the isolation levels listed in the following table. JDBC isolation levels are mapped to the appropriate DB2 transaction isolation levels as shown. The default isolation level is Read Committed.
| JDBC Isolation Level | DB2 Isolation Level |
|---|---|
| None | No Commit 1 |
| Read Committed (default) | Cursor Stability |
| Read UnCommitted | Uncommitted Read |
| Repeatable Read | Read Stability |
| Serializable | Repeatable Read |
1 Supported for DB2 for i versions that do not enable
journaling.