Subject | Re: Lock conflict |
---|---|
Author | glenndetollenaere |
Post date | 2008-04-25T13:29:17Z |
Hi Dmitry,
we use the Super Server binaries on Win XP / Vista.
regards,
Glenn
--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:
we use the Super Server binaries on Win XP / Vista.
regards,
Glenn
--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:
>server.
> glenndetollenaere wrote:
> >
> > an "explicit" lock (or pessimistic lock):
> >
> > SELECT * FROM {table} WHERE {whereclause} WITH LOCK;
> >
> > prevents the record from being changed by other users at the same time
> > (getting a lock conflict-message, which is ok).
> >
> > If the PC is turned off however, this LOCK remains on the serverside,
> > so the only way to "free" the record is by restarting the FireBird
>
> What FB architecture do you use: SuperServer or Classic Server?
>
>
> Dmitry
>