ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Odelya YomTov" <ode...@jpost.com>
Subject Problem with connecting
Date Tue, 08 Sep 2009 08:45:29 GMT
Hi!

Once a day I get the following message:

javax.servlet.ServletException: Failed to execute queryForObject - id
[getUserByNameAndPassword], parameterObject
[il.co.yalkut.data.UserData@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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message