maxIdleTime seemed to do it. I actually lowered my timeout to 30 seconds like on our production MySQL server and set maxIdleTime to 20 seconds and if I watch the processlist, it will reconnect every 20 seconds with approximately 3 connections. I've seen the SQL statement parameter too because I think a lot of people tweak that to use SELECT 1 instead of whatever the default is. Scott Battaglia wrote: > Kevin, > > There is also a parameter to test for stale connections by executing a > SQL statement. Check the c3p0 documentation for the exact name of > it. If I happen to see it in any of our configuration code here I'll > pass it along. > > -Scott > > On Dec 12, 2007 8:06 AM, Kevin Jordan <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Hopefully I think I've found it in the maxIdleTime property for c3p0 > which I set to just before the wait_timeout in my.cnf. Unfortunately > that requires me waiting about that amount of time to see if it does > time out, so if any one does know if that will fix it, let me know, > otherwise I'll post back when it's been idle 8~12 hours. Thanks. > > Kevin Jordan wrote: > > After many hours of non-use (12 or more) the MySQL connection > will time > > out and thus the first person to reconnect will get an EOFException > > error. I tried to make my application use c3p0 to pool the data > > connections for the connector j driver, but even that ends up > timing > > out. Is there any config option I can pass to avoid having this > error > > come up? > > _______________________________________________ > > Yale CAS mailing list > > [email protected] <mailto:[email protected]> > > http://tp.its.yale.edu/mailman/listinfo/cas > > > > _______________________________________________ > Yale CAS mailing list > [email protected] <mailto:[email protected]> > http://tp.its.yale.edu/mailman/listinfo/cas > > > > > -- > -Scott Battaglia > > LinkedIn: http://www.linkedin.com/in/scottbattaglia > ------------------------------------------------------------------------ > > _______________________________________________ > Yale CAS mailing list > [email protected] > http://tp.its.yale.edu/mailman/listinfo/cas >
_______________________________________________ Yale CAS mailing list [email protected] http://tp.its.yale.edu/mailman/listinfo/cas
