Subject Connection lost after some idle time
Author Denis Sodol
Hi All,

After the connection to the Firebird server (1.5.1) is idle for some
time (like 20 or 30 minutes, really hard to determine exact time),
i'm getting the following error:

Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Unable to complete network request to host "firebird". Error reading
data from the connection.
An existing connection was forcibly closed by remote host.

This happens in my applications and IBExpert as well; most frustrating
is that I get this error also in applications running under Tomcat
using DBCP with "remove abandoned connections" option on.

The host(s) and clients are on Windows XP Professional and Windows
2000 Server.

Firebird conf file mention some 2-hour default interval ("If you do
not like default 2-hour keepalive timeout then adjust your server OS
settings appropriately."), but in my case it's not even close to 2
hours - like I mentioned earlier it's about 30 minutes, probably even
less.

Any help would be greatly appreciated.