Subject RE: [firebird-support] Hanged up transactions
Author bogdan
Sorry - top post, i hope Helen will not be too angry (I like Top posting a
lot more than the other option - no time at all and problems linked one to
and all problems on-line (in my head of course))

TCP keep alive - very well - i just couldn't resist.

Sorry Helen


[] On Behalf Of Michael Ludwig
Sent: Monday, December 20, 2010 2:17 PM
Subject: Re: [firebird-support] Hanged up transactions

Ramiro Barreca schrieb am 20.12.2010 um 09:39 (-0300):

> I need to know if there is a server parameter to manage this idle
> attachments or really finished but appears as STARTED.

Do a web search for: Windows TCP Keepalive.

Incidentally, the first match I found (German) mentions Firebird:

(Just in case you wonder, the girl on the photo is Germany's top expert
on Windows TCP Keepalive. :-)

> Is there some other recommendations to the development team to manage
> transactions better to avoid this problems.

Ensure committing or rolling back transactions, for example by a proven
code template for your development language, or by paying close
attention to always clean up in a "finally" block.

> Our platform:
> Windows 2003 server R2
> FB superserver
> client apps: VB, Delphi, IBexpert
> around 500 concurrent clients.

Michael Ludwig

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