Re: Which transaction isolation level can prevent lost updates?

From: Arno Huetter <huetter_at_grz.at>
Date: 28 Nov 2002 09:23:57 -0800
Message-ID: <a710c60d.0211280923.72f3bb80@posting.google.com>

Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<uel96c04i.fsf_at_standardandpoors.com>...
> On 26 Nov 2002, huetter_at_grz.at wrote:
>
> > Most vendors implement pessimistic-locking on applicatin level,
> > so the developer should not really be concerned with these kind
> > of issues.
>
> How do they implement pessimistic-locking without "select for
> update".

Most containers do, e.g. using SELECT FOR UPDATE, or explicit row locking, some even let you configure which locking strategy to employ. Mine doesn't, unfortunately.

Kind regards,
Arno Huetter Received on Thu Nov 28 2002 - 11:23:57 CST