MySQL connection error after timeout

[Scott Battaglia]

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



-- 
-Scott Battaglia

LinkedIn: http://www.linkedin.com/in/scottbattaglia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://tp.its.yale.edu/pipermail/cas/attachments/20071212/1cbee0b0/attachment-0001.html