Subject Re: [IBO] PessimisticLocking problem.
Author guido.klapperich@t-online.de
Some weeks ago, I asked a question about pessimistic locking and you answered,
that it is no good idea, that two persons work on the same data at the same
time. Is this not the advantage of C/S-Databases, that several persons can work
simultaneously on the same data ?


Guido

"Claudio Valderrama C." wrote:

> Help says you cannot use Pessimistic Locking with ServerAutocommit. If it
> obvious if you understand how IB works.
> Probably the message is misleading here.
> The best thing you can do is to plan your application for optimistic locking
> and only use pessimistic in very special scenarios. BTW, most C/S engines
> have introduced optimistic locking recently.
>
> C.
>
> > -----Original Message-----
> > From: Marco Carosi [mailto:marcoc@...]
> > Sent: Sábado 3 de Marzo de 2001 12:50
> >
> > Hi,
> > I have download IBO for evaluations and with it I have writhed a simple
> > program, I want use the PessimisticLocking set to true, but when I try to
> > edit a record the program generate a error:
> >
> > "Cannot use pessimistic locking with LockWait"
> >
> > This is my setting:
> >
> > Transaction.ServerAutoCommit:=True;
> > Transaction.Isolation:=tiCommitted;
> > Transaction.RecVersion:=False;
> > Transaction.LockWait:=False; // *LockWait is false* !!!!!
> >
> > Query.Active:=False;
> > Query.AutoFetchAll:=False;
> > Query.AutoFetchFirst:=True;
> > Query.AutoPostDelete:=True;
> > Query.ColorScheme:=True;
> > Query.FetchWholeRows:=False;
> >
> > Query.GetServerDefaults:=False;
> > Query.IB_Connection:=Connection;
> > Query.IB_Transaction:=Transaction;
> > Query.PreventDeleting:=False;
> > Query.RequestLive:=True;
> > Query.PessimisticLocking:=True;
> >
> > Where I made the mistake ?
> >
> > Many thanks, Marco
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/