When I run the CVS version on tomcat 5.5 and Mysql 4.1, the datasource loses it's connection every night and doesn't recover from it. Each morning I have to restart the tomcat server.
After a quick look in the code I have fixed the problem with following pieces of code in de C3P0PooledConnection:
Now I'm going to test the connection before returning it to the application. If it fails, I'm refreshing the entire connection pool.
[Edit[Sorry, this is in the wrong subforum, can you move it to the correct one. Thanks[/Edit] [originally posted on jforum.net by mortis__rigor]
I'm sorry too that those sollutions didn't fixed the problem.
However, I did some code reading and did find the solution. I added the following parameter to the configuration file:
database.ping.delay=<time in seconds> [originally posted on jforum.net by mortis__rigor]