JDBC Connection pool not reopening Connections in tomcat

[Dean Chester]

Hi, I have set up tomcat to use a connection pool yet after the mysql timeout on connections the connections previously open in the pool are not opened.Here is what my context.xml file looks like:

  <Resource name="jdbc/hpsgDB" auth="Container" type="javax.sql.DataSource"
           maxActive="5" maxIdle="3" maxWait="10000"
           username="uname" password="password" driverClassName="com.mysql.jdbc.Driver"
           url="jdbc:mysql://localhost:3306/hpsgdb?autoReconnect=true"/>  

As you can see i have included autoReconnect as true yet it doesn't. I have checked the process on the database after 8 hours which is what the time out is set to. If anyone can help then please help me as this has been a problem for a few months yet has just cropped up as urgent due to my software going live soon.
Thanks in Advance
Dean Chester

[Misha Ver]

Try using validationQuery property

 <Resource name="jdbc/hpsgDB" auth="Container" type="javax.sql.DataSource"
           maxActive="5" maxIdle="3" maxWait="10000"
           username="uname" password="password" driverClassName="com.mysql.jdbc.Driver"
           url="jdbc:mysql://localhost:3306/hpsgdb?autoReconnect=true"
           validationQuery="Select 1" /> 
 

[Dean Chester]

Thanks Misha that seems to have fixed the error.
Dean