I am not sure if this is a Tomcat issue or hibernate so I have posted this on both forums.

I deploy an application to Tomcat and it runs for about a day then when I come in the following day I can pull up my applications web pages but I can’t retrieve or add anything to the database. But, if I go and reload that app in Tomcat then everything works great for about a day then it doesn't work again and I go through the whole process all over. I really don’t have a clue on this. I am using Hibernate for my OR mapping and MySQL for the database.

Any help would be great!

Thanks

Hibernate version: 2.1.8

Sounds to me like a MySQL issue ;-)

You should check all your tomcat logs for an exception like
java.sql.SQLException: Communication link failure

In this case the MySQL server closed the connection on the server side invalidating your connection in your pool because the connection's idle time exceeded the wait_timeout of your MySQL server.

You can fix this by increasing the wait_timeout variable in your MySQL server or (better?) by using a connection pool which is able to validate and recreate connections before use (e.g. c3p0).

You should also add autoReconnect=true to your connection URL.

Thanks for all the input. After using C3P0 I am not losing my connection anymore. :)