Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which transaction isolation level can prevent lost updates?

Re: Which transaction isolation level can prevent lost updates?

From: Brian E Dick <bdick_at_cox.net>
Date: Tue, 26 Nov 2002 11:51:58 GMT
Message-ID: <yfJE9.29020$wc2.1290111@news2.east.cox.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US