|
Posted by dhek on 11/04/07 12:27
> I know that the isolation level should be either REPEATABLE READ or
> SERIALIZABLE. But I need confirmation on if one of these actually solve my
> issue - prevents other applications/threads from modifying/inserting data
> into the same tables that I'm working on.
When reading about SERIALIZABLE in
http://en.wikipedia.org/wiki/Isolation_(computer_science) I get the
understanding that the objects involved in a SELECT-statement (that is all
coloumns involved i vaious tables) will be locked. In essence this would
render it impossible to insert new records into the tables used in my
SELECT-statement which I believe is exaclty what I need.
Is this understanding correct?
Navigation:
[Reply to this message]
|