It has been 10 days so I am declaring that Jason's suggestion did indeed
solve the problem.
Thanks Jason.
- Original Message -
From: "Steve Ryder"
To: "Tomcat Users List"
Sent: Thursday, October 07, 2010 10:03 AM
Subject: Re: Tomcat5.5 MySQL14.12 java.net.Soc
Thanks Jason. I have added the two parameters. Hopefully I will have seen
the last of this error.
- Original Message -
From: "Jason Britton"
To: "Tomcat Users List"
Sent: Wednesday, October 06, 2010 11:57 PM
Subject: Re: Tomcat5.5 MySQL14.12 java.net.SocketEx
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
Jaso
