Sets the isolation level of the changes made by the programs.
|Read Committed ||In this isolation level the programs do NOT see the changes made by other users until they perform a COMMIT. This is the default value. |
|Read Uncommitted ||In this isolation level the programs see the changes made by other users even if they haven't performed a COMMIT yet.|
Setting Isolation level affects read phenomena and concurrency control. Using Read Committed provides higher consistency levels but generates more locks on the database. There is more information about Isolation Level at https://en.wikipedia.org/wiki/Isolation_(database_systems) and the documentation of different DBMSes.
- The property is read-only for Oracle and its value is Read Committed (Oracle Database doesn't use dirty reads, nor does it even allow them)
- The isolation level used for SQLite (Android and iOS programs) is Read Committed.
This property applies only at design-time.
To apply changes made by this property, do a Re-Build All.
Available at the datastore.
Datastore: Iseries, DB2 UDB, INFORMIX, MYSQL, ORACLE, POSTGRESQL, SQLSERVER
Platforms: Web(.Net, Java)