Repeatable Read Isolation Level
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Chris_Noseworthy
Posted On:   Thursday, January 3, 2002 02:42 PM

Short and simple.
Will the Repeatable Read Isolation Level
Lock the SELECTed rows from modification by others transactions?

Re: Repeatable Read Isolation Level

Posted By:   Bozidar_Dangubic  
Posted On:   Friday, January 4, 2002 05:38 AM

a repetable read is when data is guaranteed to look the same if read again during the same transaction. this guarantee is implemented in one of two ways:

  1. data is locked against changes
  2. data read is a snapshot that does not reflect any changes made during the transaction by other transactions

so your answer is - depends on the implementation. the only sure way to check is to run a test.
About | Sitemap | Contact