Subject Re: [IBO] How to emulate lock wait timeout?
Author Michael Fung <ibo@cmsweb.com>
Dear Jason,

Sorry to tell you that I am no good at low level programming. I
supposed you would implement it if possible ;} Anyway, don't bother
if you have other more important task going on (port IBO to Kylix).

Rgds,
Michael


--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
wrote:
> 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@c...>
> 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