What are Isolation level in Connection Pool Setting ??
They are applicable for ODBC and DB2 gateways only.
The Level options:
Committed Read: Locks are held while the data is read to avoid dirty reads. Data can be changed before the transaction ends with that connection.
Dirty Read: 0 Locking. Can read uncommitted or dirty data, change values in data during read process in a transaction. Least restrictive of all types.
Repeatable Read: Places locks on all data used in a query so that nobody can update the data. However new rows can be inserted by other users but will be available in later reads in the current transaction.
Serialization: Places a range lock on data set preventing other users to insert or update the rows in data set until the transaction is complete. Most restrictive of all.
Showing posts with label Isolation Level. Show all posts
Showing posts with label Isolation Level. Show all posts
Sunday, March 10, 2013
Subscribe to:
Posts (Atom)