Subject RE: [IBO] Threaded transaction not advancing - Additional Detail
Author Bill Morrison
Thanks for the answer Jason. The culprit is indeed some open cursors.

I didn't realize that an open cursor would keep an open transaction
regardless of explicit commits of it's transaction.

Thanks again for the answer!


-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Tuesday, October 23, 2001 10:47 AM
Subject: Re: [IBO] Threaded transaction not advancing - Additional


> 1) If I look through the TIB_Connection.Transactions[] property, all of
> return false for intransaction.

InTransaction isn't directly tied to the physical transaction handle. Use
the Started property for that.

> 2) If I disconnect and reconnect the database, it releases the OAT.

You are probably leaving a cursor open.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Bill Morrison" <bmorrison@...>
To: <>
Sent: Tuesday, October 23, 2001 10:16 AM
Subject: RE: [IBO] Threaded transaction not advancing - Additional Detail

> Two further notes:
> Bill
> -----Original Message-----
> From: Bill Morrison [mailto:bmorrison@...]
> Sent: Tuesday, October 23, 2001 9:12 AM
> To: ''
> Subject: [IBO] Threaded transaction not advancing
> I'm having a weird problem with 3.6.Dg running against IB 5.6.
> I have a datamodule that I am creating in a thread. This datamodule has a
> TIB_Connection component, to TIB_Transactions (tiCommitted), and some
> and dsql components.
> Now, if this datamodule is created outside of the thread (I was
> inadvertantly creating it in the thread's constructor (main thread
> context)), then everything runs fine, and the transactions advance
> However, once I started creating the datamodule in the threads execute
> method, the OAT and OIT will cease advancing on the server.
> All of the cursors and dsql are connected to one or the other
> and the transactions are committing every ten seconds or so. Even manually
> setting a breakpoint and committing them in debug mode will not increment
> the OAT and OIT.
> Interestingly, if I look at the transactioncount property of the
> TIB_Transaction, it returns 3. I thus assume that the third transaction is
> being created internally for some IBO internal housekeeping, and is for
> reason not incrementing it's OAT.
> Any assistance with this problem would be greatly appreciated!
> Bill Morrison

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to