Subject | Re: [firebird-support] Connection lost after some idle time |
---|---|
Author | Helen Borrie |
Post date | 2005-03-03T09:26:04Z |
At 07:18 AM 3/03/2005 +0000, you wrote:
that is the current setting. An application could have overridden the
default.
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
>Hi All,This applies to TCP/IP connections, of course. "Default" does not mean
>
>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.
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