Isolation level property

Official Content
This documentation is valid for:
Sets the isolation level of the changes made by the programs.

Values

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.

Description

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. 

Important:

  • 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.

Run-time/Design-time

This property applies only at design-time.

How to apply changes

To apply changes made by this property, do a Re-Build All.

Scope

Available at the datastore.
Datastore: Iseries, DB2 UDB, INFORMIX, MYSQL, ORACLE, POSTGRESQL, SQLSERVER
Platforms: Web(.Net, Java)

See Also

Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.