[ http://issues.apache.org/jira/browse/IBATIS-158?page=comments#action_12314206 ]
Sven Boden commented on IBATIS-158: ----------------------------------- Which SQL statement do you use for "Pool.PingQuery" in the DataSource/ConnectionPool properties? And if possible could you attach that property file to the issue. Regards, Sven Boden > After running for a couple of days handles are being returned to the pool??? > ---------------------------------------------------------------------------- > > Key: IBATIS-158 > URL: http://issues.apache.org/jira/browse/IBATIS-158 > Project: iBatis for Java > Type: Bug > Environment: Gentoo Linux > Reporter: Skoob > > If I do /etc/init.d/tomcat5 restart then everything starts working again for > an arbitrary amount of time. > Here is the stack Trace. > Exception: > --- The error occurred in > com/mycompany/persistence/sqlmapdao/sql/myStmts.xml. > --- The error occurred while executing query. > --- Check the SQL Statement (preparation failed). > --- Cause: com.ibatis.common.exception.NestedRuntimeException: Error > accessing SimplePooledConnection. Connection has been invalidated (probably > released back to the pool). > Stack trace: > Length: 56 > at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:184) > at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584) > at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105) > at > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77) > at > com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:203) > at sun.reflect.GeneratedMethodAccessor1074.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:64) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
