Posted by dhek on 11/03/07 10:24

Hi,

I have 1 SQL statement selecting data from various tables and updating other
tables.

The question then is how do I prevent other applications from modifying the
tables that I'm working on (that is while my transaction is being executed)?


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.



Thanks in advance,
Daniel

• Next in forum: Re: Transaction Isolation Level
• Prev in forum: Re: update hierarchy
• Thread view: Transaction Isolation Level

[Reply to this message]