Hi, we had a problem with Hibernate and MySQL: the database connection gets closed after 8 hours when it's idle. So on our dev server, after 8 hours idle, the connection got closed and we got errors with our applications.
So we googled and found that: http://www.databasesandlife.com/automatic-reconnect-from-hibernate-to-mysql/ which is not 100% true because here http://stackoverflow.com/questions/3123962/hibernate-and-mysql-timeout-problem-doesnt-work-with-c3p0 they state that you have to implement a custom LocalSessionFactoryBean to get c3p0 working because of a spring bug. We did that and now we don't have the connection problems with our applications anymore. But: we get that same error message as you do and now my first guess would be that in our case while hibernate is now connected via c3p0, magnolia is not and thus the problem now occurs for our magnolia instance (which uses MySQL). tldr: MySQL disconnects after 8 hours idle without usage of c3p0 -> problem for magnolia? Anyone having similar setup/problems? Greetings, Anton ---------------------------------------------------------------- For list details see http://www.magnolia-cms.com/home/community/mailing-lists.html To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
