Sounds like you need to use a validation query to ensure your connections are not stale.
On Sun, Jan 25, 2009 at 10:06 AM, Zsolt Koppany <[email protected]>wrote: > Hi, > > after getting the Exception below I get lot of database related Exceptions. > > What happens if ibatis finds an invalid connection? Will that be removed > from the pool? > > What should the application do to prevent such problems? > > We use ibatis 2.3.4.726 with mysql-5.0.67. > > Zsolt > > 2009-01-25 15:32:43,436 ERROR servlet.build.BackgroundBuildTimerTask - > java.lang.RuntimeException: Error accessing SimplePooledConnection. > Connection is invalid. [DefaultQuartzScheduler_Worker-2] > java.lang.RuntimeException: Error accessing SimplePooledConnection. > Connection is invalid. > at > com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.getValidConnection(SimpleDataSource.java:913) > at > com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.invoke(SimpleDataSource.java:958) > at $Proxy0.rollback(Unknown Source) > at > com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.rollback(JdbcTransaction.java:72) > at > com.ibatis.sqlmap.engine.transaction.TransactionManager.end(TransactionManager.java:87) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:734) > at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:176) > at > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:153) > at > com.intland.codebeamer.persistence.util.SqlMapClientWrapper.endTransaction(SqlMapClientWrapper.java:251) > > Zsolt >
