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 |
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |