Hi!
Once a day I get the following message:
javax.servlet.ServletException: Failed to execute queryForObject - id
[getUserByNameAndPassword], parameterObject
[il.co.yalkut.data.userd...@4d8d50]. Cause:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in il/co/yalkut/dbaccess/sql/User.xml.
--- The error occurred while applying a parameter map.
--- Check the getUserByNameAndPassword-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last
packet successfully received from the server was42677 milliseconds ago.The
last packet sent successfully to the server was 42677 milliseconds ago,
which 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.
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last
packet successfully received from the server was42677 milliseconds ago.The
last packet sent successfully to the server was 42677 milliseconds ago,
which 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.
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.
java:523)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
I added &autoReconnect=true to the url in database.properties but it doesn't
help!
What can I do?
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
