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!



Bill

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


Bill,

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

them

> 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.

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

----- Original Message -----
From: "Bill Morrison" <bmorrison@...>
To: <IBObjects@yahoogroups.com>
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: 'ibobjects@yahoogroups.com'
> 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
cursor
> 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
normally.
>
> 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
transactions,
> 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
some
> 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.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/