Sunday, March 10, 2013

Isolation level in Connection Pool

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.

No comments:

Post a Comment