Re: can't access database after timcat idle for several hours

2006-04-28 Thread ALEX HYDE
'If' your web srver is firewalled off from your database server and 'if' it turns out that the firewall is timing out your connections at a TCP/IP level, then the Proxool pool could be useful. Gluck --- james edwards <[EMAIL PROTECTED]> wrote: > Opps, sorry I forgot to mention that I am running

RE: can't access database after timcat idle for several hours

2006-04-28 Thread Tim Lucia
Users List Subject: Re: can't access database after timcat idle for several hours Sounds to me like your database is timing out the connection. See if you can extend the timeout so it won't drop it during an overnight lull. james edwards wrote: > No, different machines. But, it work

Re: can't access database after timcat idle for several hours

2006-04-28 Thread Gustavo Noronha
2006/4/28, David Kerber <[EMAIL PROTECTED]>: Sounds to me like your database is timing out the connection. See if you can extend the timeout so it won't drop it during an overnight lull. This seems probable, indeed. I would recommend setting up some kind of connection checking, that would ma

Re: can't access database after timcat idle for several hours

2006-04-28 Thread David Kerber
Sounds to me like your database is timing out the connection. See if you can extend the timeout so it won't drop it during an overnight lull. james edwards wrote: No, different machines. But, it works all day and works right after a restart of tomcat. j On 4/28/06, ALEX HYDE <[EMAIL PROTEC

Re: can't access database after timcat idle for several hours

2006-04-28 Thread james edwards
Opps, sorry I forgot to mention that I am running continuous pings between the tomcat and database server and not seeing any drops. james

Re: can't access database after timcat idle for several hours

2006-04-28 Thread james edwards
No, different machines. But, it works all day and works right after a restart of tomcat. j On 4/28/06, ALEX HYDE <[EMAIL PROTECTED]> wrote: Are they on the same machine? If not it could be a firewall issue? It could be alot of things but that's a start. --- james edwards <[EMAIL PROTECTED]> w

Re: can't access database after timcat idle for several hours

2006-04-28 Thread ALEX HYDE
Are they on the same machine? If not it could be a firewall issue? It could be alot of things but that's a start. --- james edwards <[EMAIL PROTECTED]> wrote: > I am running 3 servers; Apache, Tomcat (5.5.16, java > version "1.5.0_06", > Informix JDBC-1.3.00.JC3) and Informix (7.31.UD2). > After