Subject Re: [IBO] How to emulate lock wait timeout?
Author Jason Wharton
Possibly so. Give it a try and let me know how it goes. Although, it seems I
may need to help you with how to set the TPB in the OnCustomizeTPB event.
That is so you can control more accurately the transaction parameter block
sent to the server when starting a transaction. Please see if you can just
figure it out using the IB API documentation and writing in the appropriate
bytes to the buffer passed in.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --


----- Original Message -----
From: <ibo@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, January 22, 2003 10:01 PM
Subject: Re: [IBO] How to emulate lock wait timeout?


> Jason,
>
> For a workaround, is it possible to add a lock_retry_count property
> to ib_query such that the query retries automatically for
> lock_retry_count times if it encounter a lock conflict error?
>
> Rgds,
> Michael
>
>
> --- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
> wrote:
> > This is really an issue for the Firebird/InterBase community.
> > I don't think there is currently a timeout feature for this.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> > -- We may not have it all together --
> > -- But together we have it all --
> >
> >
> > ----- Original Message -----
> > From: <ibo@c...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Tuesday, January 21, 2003 7:57 PM
> > Subject: [IBO] How to emulate lock wait timeout?
> >
> >
> > > Dear all,
> > >
> > > I need to enable Lock Wait in IB_transaction, but I also want to
> > > timeout after waited a specified time. Is it possible to do this?
> If
> > > yes, could you give me some hints?
> > >
> > > Thanks.
> > > Michael