Subject Re: [firebird-support] Connection lost after some idle time
Author Helen Borrie
At 07:18 AM 3/03/2005 +0000, you wrote:



>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.

This applies to TCP/IP connections, of course. "Default" does not mean
that is the current setting. An application could have overridden the
default.

>Any help would be greatly appreciated.

If you are using TCP/IP, this would be a good place to start:
http://support.microsoft.com/kb/314053

Note particularly the keys "KeepAliveTime" and "KeepAliveInterval".

If you are using Named Pipes, there will be something equivalent. You'll
find your answer somewhere with a Google search.

./heLen