Subject Re: [firebird-support] Re: Terminate Long Running Transaction
Author Slalom
What a shame.

Is there any way to specify a setting on the client to disconnect after a certain period of time?

It does not seem logical to me that the garbage collector should wait indefinitely and thus peg the CPU.


----- Original Message ----
From: Adam <s3057043@...>
To: firebird-support@yahoogroups.com
Sent: Tuesday, January 2, 2007 10:07:35 PM
Subject: [firebird-support] Re: Terminate Long Running Transaction

--- In firebird-support@ yahoogroups. com, "slalom91" <slalom91@.. .> wrote:
>
> Is there a way to have the server terminate a long running
> transaction?
>
> I have a multi-threaded, multi-tier application with a FB 1.5.3 DB.
> Every once in a while a thread fails / leaks and I would like to find a
> way to kill the transaction within the thread. Since my application is
> losing it's handle to the thread I am hoping there is a setting on the
> server that can help me here.

With Classic server you can task kill the corresponding connection,
but asides from that no.

Adam




[Non-text portions of this message have been removed]