Subject Re: [firebird-support] Hanged up transactions
Author Michael Ludwig
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:

http://www.consic.de/support/keepalive.htm

(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 2.1.1.179
> client apps: VB, Delphi, IBexpert
> around 500 concurrent clients.

--
Michael Ludwig