Re: SimplePooledConnection Exception

[Zsolt Koppany]

Nathan,

we do that.

Zsolt

Nathan Maves schrieb:

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 <zkoppanyl...@intland.com <mailto:zkoppanyl...@intland.com>> 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