Re: Tomcat and MySQL sync problems

2007-01-29 Thread Mark Thomas
Luiz Siqueira wrote: > Sorry about this message but I'm a little despaired. > > I create a JAR library with the business logic, I use Hibernate and > MySQL. Everything work fine but when I try use the JAR from a WebApp > using the bundled TomCat on NetBeans 5.5 I got an server error. I > believe t

Re: Tomcat and MySQL sync problems

2007-01-29 Thread Martin Dubuc
Not sure if it is the same problem, but we had similar issue and resolved it by increasing value of wait_timeout in /etc/my.cnf: wait_timeout=2147483647 I am not sure if the issue we were seeing was tied wth Tomcat or not though. Martin On 1/29/07, Chris Long <[EMAIL PROTECTED]> wrote: Hello,

Re: Tomcat and MySQL sync problems

2007-01-29 Thread Luiz Siqueira
> >Hopefully someone else may clue you in better, but you may want to check >the datasource props and see if this is valid. > > >Scott > >-Original Message- >From: Chris Long [mailto:[EMAIL PROTECTED] >Sent: Monday, January 29, 2007 8:54 AM >To: users@tomcat.apache.

Re: Tomcat and MySQL sync problems

2007-01-29 Thread David Smith
ris Long [mailto:[EMAIL PROTECTED] >Sent: Monday, January 29, 2007 8:54 AM >To: users@tomcat.apache.org >Subject: Tomcat and MySQL sync problems > >Hello, > >I'm having a problem where it seems Tomcat and MySQL go out of sync and >I am >no longer able to connec

RE: Tomcat and MySQL sync problems

2007-01-29 Thread Scott Purcell
see if this is valid. Scott -Original Message- From: Chris Long [mailto:[EMAIL PROTECTED] Sent: Monday, January 29, 2007 8:54 AM To: users@tomcat.apache.org Subject: Tomcat and MySQL sync problems Hello, I'm having a problem where it seems Tomcat and MySQL go out of sync and I

Re: Tomcat and MySQL sync problems

2007-01-29 Thread Andreas Deller
Hi We had a simliar problem with Oracle and Tomcat 4.1.30 and a firewall in between and I don't remember the exact error message, so I'm not sure if this helps: The problem was that Tomcat held the DB connection open infinitely, and the firewall after a while decided it wanted to drop the connect

Tomcat and MySQL sync problems

2007-01-29 Thread Chris Long
Hello, I'm having a problem where it seems Tomcat and MySQL go out of sync and I am no longer able to connect to the MySQL database. The only way I've found to be able to reconnect to my database is to restart Tomcat. This generally seems to happen some time over the course of the night and I n