hi all ! Im having an issue with my app, when the app is left "iddle" during the night when someone tries to connect in the next morning they get an error saying:
The last packet sent successfully to the server was 72.264.329 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
This is the context.XML wich controls the connection pool:
<Resource auth="MyApp" driverClassName="com.mysql.jdbc.Driver" maxActive="-1"
maxIdle="20" maxWait="10000" name="jdbc/MedPro" password="admin" removeAbandoned="true"
removeAbandonedTimeout="60"
type="javax.sql.DataSource" url="jdbc:mysql://127.0.0.1:3306/Myapp?autoReconnect/autoReconnectForPools=true" username="root"/>
Im using Mysql server 5.1 and Jconnector 5.1.11
Any help is appreciated.
THanks in advance.
Edited by: juanmanuelsanchez on Feb 20, 2010 5:09 PM