Re: Which transaction isolation level can prevent lost updates?

From: Arno Huetter <huetter_at_grz.at>
Date: 25 Nov 2002 22:30:47 -0800
Message-ID: <a710c60d.0211252230.4a7f4972@posting.google.com>

Daniel,

I am facing this problem, believe me. Plus, this was a very simplified version of my transaction scenario. The "i = i + 1" part is much more complex in reality. I cannot invoke SELECT FOR UPDATE, as I employ container-managed entity java beans.

Kind regards,
Arno Huetter

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3DE2943C.B7201C05_at_exesolutions.com>...
>
> In Oracle the chances of this problem happening is so remote that I can't
> think of anyone that does anything to code around it. Definitely not
> changing isolation levels.
>
> Are you sure you really have a problem that can't be solved with SELECT
> FOR UPDATE?
>
> Daniel Morgan
Received on Tue Nov 26 2002 - 00:30:47 CST