Hi I have a problem, after some time of inactivity like 1 hour I get the following error, if I restart the container everything works fine again, but after one hour the same again. I would appreciate it if somebody could help me. thanks. Raul.

Hibernate version:
2.1

Full stack trace of any exception that occurs:

java.lang.RuntimeException: net.sf.hibernate.JDBCException: Could not execute query
com.estudiowebs.BO.ProductBO.getProductList(ProductBO.java:295)
com.estudiowebs.Controller.ProductList.doGet(ProductList.java:63)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)


Name and version of the database you are using:

MySQL 4

I seem to recall some setting that you can specify to the driver (autoreconnect??) that prevents this sort of behaviour with MySQL- search the forums - it has come up before.

and just in case you were wondering - you can specify it in the properties file using

thanks for your quick response :), does that mean that I have to try to reconnect to mysql manually or is there a way to tell hibernate to do it.

Thanks :) this is really helpfull. I'm gonna try it. Did you have the same type of problem?

Yes. But it went away when I migrated to postgres ;-)

(BTW Postgres 8.0 comes as a windows installer)