Subject Re: [firebird-support] How to find a transaction in the code given TID?
Author Alexandre Benson Smith
Krzysztof Koz³owski wrote:
> Hi,
> I have gota following problem. I am using the Firebird database for
> the application I am developing, and while looking through Transaction
> Inventory Pages I have found out, that I have a transaction which has
> been started some time ago, but is still active (supposedly hasn't
> been commited while it should have). I have got it's ID, now I am
> wondering how can I find this uncommited transaction in the code of my
> application. I am using TIBClientDataSet, TIBQuery and TIBSQL for
> changing the DB content. Do these components have any access to the
> Transaction IDs which is being created while these are opened/executed?
> Regards,
> Krzysztof

I think the only way you will achieve without modifying your client app
this is using FB 2.1 that is in BETA.

Another option is to inside your app you register in a log table every
time you start a transaction something like ip number (could be get
inside FB 2.0) application name, routine name, etc.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil