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
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 that the problem is that the serv

Re: Tomcat and MySQL sync problems

2007-01-29 Thread David Smith
It appears your code is holding on to a connection to the database. Bad design practice. Review your code for any place that might keep hold of a connection between requests and make sure the connection is closed. Also, If you haven't done so yet, use a database connection pool. If using tomca

RE: Tomcat and MySQL sync problems

2007-01-29 Thread Scott Purcell
If I remember correctly, MySQL basically disconnects and shutdowns after a certain amount of time. I remember doing something with a "reload="true" in the datasource to prevent this. Hopefully someone else may clue you in better, but you may want to check the datasource props and see if this is va

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