tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Kerber <dcker...@verizon.net>
Subject Re: can't access database after timcat idle for several hours
Date Fri, 28 Apr 2006 20:19:11 GMT
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 <alex.hyde@btinternet.com> 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 <lists.james.edwards@gmail.com>
>> 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 the app has been idle for several hours tomcat
>> > cannot access the
>> > database. Netstat shows not connections to the
>> > database
>> > and tcpdump shows no traffic at all going the
>> > database when queries are made
>> > to the app (which would cause the database to be
>> > consulted)
>> > At first it seemed that the overnight backup of the
>> > database was causing
>> > this problem but restarting tomcat after the backup
>> > only fixes this problem
>> > for a few more hours.
>> > I wrote a loop to wget url's that cause the database
>> > to be consulted every
>> > 60 sec but after several hours this problem happens
>> > again. Tomcat seems to
>> > be fine, I can load the
>> > management page and restart the app. Only restarting
>> > tomcat fixes this
>> > problem, reloading the app does not fix the
>> > problem.. Nothing is being
>> > logged during and right before this problem.
>> >
>> > Does anyone have suggestions to further debug this
>> > problem ?
>



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message