DTC has a set of isolation levels, which the application server specifies. These isolation levels map to SQL Anywhere isolation levels as follows:
| DTC isolation level | SQL Anywhere isolation level |
|---|---|
| ISOLATIONLEVEL_UNSPECIFIED | 0 |
| ISOLATIONLEVEL_CHAOS | 0 |
| ISOLATIONLEVEL_READUNCOMMITTED | 0 |
| ISOLATIONLEVEL_BROWSE | 0 |
| ISOLATIONLEVEL_CURSORSTABILITY | 1 |
| ISOLATIONLEVEL_READCOMMITTED | 1 |
| ISOLATIONLEVEL_REPEATABLEREAD | 2 |
| ISOLATIONLEVEL_SERIALIZABLE | 3 |
| ISOLATIONLEVEL_ISOLATED | 3 |
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |