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.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |