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]> 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] > > http://tp.its.yale.edu/mailman/listinfo/cas > > > > _______________________________________________ > Yale CAS mailing list > [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
