Google is your friend: http://forums.mysql.com/read.php?39,199085,204628#msg-204628
Larry On Mon, Jun 15, 2009 at 3:39 AM, Zsolt Koppany<[email protected]> wrote: > Hi, > > I get an exception attached at the end. Here are the ibatis pool properties: > > Pool.MaximumActiveConnections=20 > Pool.MaximumIdleConnections=5 > Pool.MaximumCheckoutTime=20000 > Pool.TimeToWait=20000 > Pool.PingEnabled=true > Pool.PingQuery=SELECT 1 FROM always_one_row > Pool.PingConnectionsOlderThan=0 > Pool.PingConnectionsNotUsedFor=5000 > > How is it possible getting this exception? "Pool.PingConnectionsNotUsedFor" > is set to 5 seconds and mysql complains that last packet was sent 758278 > seconds ago. As far as I understand for connections older than 5 seconds the > ping command should be executed and if not successful a new connection > created. > > I use ibatis-2.3.4.726. Does anybody have an idea? > > Zsolt > > 2009-06-14 14:31:19,167 ERROR dao.impl.ProjectDaoImpl - iBATIS exception > [TP-Processor489] > com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred while applying a parameter map. > --- Check the findProject-InlineParameterMap. > --- Check the statement (query failed). > --- Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last > packet successfully received from the server was758278 seconds ago.The last > packet sent successfully to the server was 758278 seconds 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. > at > com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) > at > com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) > at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:126) > at > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:102) > at > com.intland.codebeamer.persistence.util.SqlMapClientWrapper.queryForList(SqlMapClientWrapper.java:345) > >
