Subject | Re: [firebird-support] Re: Terminate Long Running Transaction |
---|---|
Author | Slalom |
Post date | 2007-01-03T15:25:42Z |
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
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]