Re: Tomcat5.5 MySQL14.12 java.net.SocketException: Broken pipe

2010-10-18 Thread Steve Ryder
PM Subject: Re: Tomcat5.5 MySQL14.12 java.net.SocketException: Broken pipe To your mysql Resource definition below I would add validationQuery=SELECT 1 That should prevent your application from getting handed stale db connections from your pool. Take a look at the testOnBorrow

Re: Tomcat5.5 MySQL14.12 java.net.SocketException: Broken pipe

2010-10-07 Thread Steve Ryder
java.net.SocketException: Broken pipe To your mysql Resource definition below I would add validationQuery=SELECT 1 That should prevent your application from getting handed stale db connections from your pool. Take a look at the testOnBorrow and validationQuery definitions here http

Tomcat5.5 MySQL14.12 java.net.SocketException: Broken pipe

2010-10-06 Thread Steve Ryder
I am getting this during mysql connection (about once a week). I have read the thread on MySQL forum, which has a solution, but the link to the solution is broken and points back to the same page. Suggestions have been use autoconnect=true Another was that the server timeout was shorter than

Re: Tomcat5.5 MySQL14.12 java.net.SocketException: Broken pipe

2010-10-06 Thread Jason Britton
To your mysql Resource definition below I would add validationQuery=SELECT 1 That should prevent your application from getting handed stale db connections from your pool. Take a look at the testOnBorrow and validationQuery definitions here http://commons.apache.org/dbcp/configuration.html Jason