need help on isolation level for transaction RRS feed

  • Question

  • Hi,


    i launch my application on two pcs (A,B) in the same time :

    Process A : transaction with repeatable read isolation level.

    Process B : Read data => the read of some data is blocked .


    and in this case :

    Process A : transaction with read uncommited isolation level.

    Process B : Read data => not blocked


    what i can't understand is why with repeatable read isolation level, the process B is blocked to read some data form the database ?


    any help please


    Thursday, July 5, 2007 4:05 PM

All replies

  • The locks hides data that is not safe for reading. The tighter lock you have, less data will be seen as acceptable for reading.

    Look at this link to see some explanations of what different locks sees as acceptable data to show.
    Thursday, July 5, 2007 4:47 PM