Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which transaction isolation level can prevent lost updates?
And your container doesn't give you hooks to modify the SQL before
submission to the RDBMS? What vendor?
"Arno Huetter" <huetter_at_grz.at> wrote in message
news:a710c60d.0211252230.4a7f4972_at_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 - 05:51:58 CST