Re: Tomcat problems every morning.

2003-06-03 Thread Chong Yu Meng
Hollerman Geralyn M wrote: Why, yes, I am. And I thought perhaps MySQL was the problem - but I was told by some people using Oracle and PostgreSQL databases that they'd seen the problem as well. To put it bluntly, don't believe them, Lynn. It seems to me like you've done everything necessary

Re: Tomcat problems every morning.

2003-06-03 Thread Hemendra Rana
:[EMAIL PROTECTED] Sent: Sunday, June 01, 2003 9:07 PM To: Tomcat Users List Subject: Re: Tomcat problems every morning. On Sun, 01 Jun 2003 18:14:05 -0700, Hemendra Rana wrote Are you using mysql database on the backend too. Someone here pointed out that by default, mysql driver times out after

Re: Tomcat problems every morning.

2003-06-03 Thread Geralyn M Hollerman
Chong Yu Meng wrote: You could write a small program (not a servlet) that polls the database (i.e. connect to the database, retrieve some data, disconnect) at regular intervals and records to a file both successes and failures. Then maybe trigger a server reboot when it detects a connection

RE: Tomcat problems every morning.

2003-06-03 Thread Januski, Ken
Just out of curiosity have you posted this question to mysql users list now that you see the problem pointing to mysql? -Original Message- From: Hemendra Rana [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 9:33 AM To: Tomcat Users List Subject: Re: Tomcat problems every morning

Re: Tomcat problems every morning.

2003-06-03 Thread Chong Yu Meng
Geralyn M Hollerman wrote: For the stuff I'm working with, *I'm* the DBA. Oops ! Sorry to hear that ! I've never had much luck with MySQL myself, because it has some pretty funky methods of configuring permissions. I use Firebird when I can. Anyway, I'm pretty sure it isn't Tomcat that is

RE: Tomcat problems every morning.

2003-06-03 Thread Januski, Ken
that I don't have with mine. -Original Message- From: Chong Yu Meng [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 12:08 PM To: Tomcat Users List Subject: Re: Tomcat problems every morning. Geralyn M Hollerman wrote: For the stuff I'm working with, *I'm* the DBA. Oops ! Sorry

Re: Tomcat problems every morning.

2003-06-03 Thread Geralyn M Hollerman
Januski, Ken wrote: For what it's worth I use Tomcat 4.0 and mySQL in production environment and don't have any of the aforementioned problems. I DO restart mySQL from script on daily basis but I never had any problems that caused me to do so. I just wanted a daily backup of the database and

Tomcat problems every morning.

2003-06-02 Thread Hemendra Rana
Hi, I am running Tomcat 4.1.24 server on Linux and every morning I get the following exception. Things work perfectly fine throughout the day after I restart the Tomcat server. Any ideas? Could this be a logger issue, because my server logs rotate every night. Any help will be appreciated.

Re: Tomcat problems every morning.

2003-06-02 Thread Jason Bainbridge
On Mon, 2 Jun 2003 01:31, Hemendra Rana wrote: I am running Tomcat 4.1.24 server on Linux and every morning I get the following exception. Things work perfectly fine throughout the day after I restart the Tomcat server. Any ideas? Could this be a logger issue, because my server logs rotate

Re: Tomcat problems every morning.

2003-06-02 Thread Hollerman Geralyn M
On Sun, 01 Jun 2003 10:31:15 -0700, Hemendra Rana wrote I am running Tomcat 4.1.24 server on Linux and every morning I get the following exception. Things work perfectly fine throughout the day after I restart the Tomcat server. Any ideas? Could this be a logger issue, because my server

Re: Tomcat problems every morning.

2003-06-02 Thread Hemendra Rana
Are you using mysql database on the backend too. Someone here pointed out that by default, mysql driver times out after every 8 hours. I still needs to verify whether that is the cause of my problem though. Will let you know of my finds. Hemendra Hollerman Geralyn M wrote: On Sun, 01 Jun 2003

Re: Tomcat problems every morning.

2003-06-02 Thread Hollerman Geralyn M
On Sun, 01 Jun 2003 18:14:05 -0700, Hemendra Rana wrote Are you using mysql database on the backend too. Someone here pointed out that by default, mysql driver times out after every 8 hours. I still needs to verify whether that is the cause of my problem though. Will let you know of my

RE: Tomcat problems every morning.

2003-06-02 Thread Paul \(BRI\)
the mySQL driver had a autoReconnect=true setting - I think I saw it on the Apache site. I hope you figure things out. Paul -Original Message- From: Hollerman Geralyn M [mailto:[EMAIL PROTECTED] Sent: Sunday, June 01, 2003 9:07 PM To: Tomcat Users List Subject: Re: Tomcat problems every