mySQL is set up to close connections from the server end after ~12 hours 
of inactivity? This is fairly common in databases.

A lot of connection pool implementations have settings for testing the 
status of connections. Perhaps that needs to go into JBossPool

Nicolai P Guba wrote:

> This is a regular thing with the mySQL connection pool.  Why?
> 
> Driver:  mm.mysql-2.0.4
> 
> 
> [CAMS] Resource 'org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl@4a9a2d' 
>enlisted for 'org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@38d6f7'.
> [CAMS] Pool CAMS [1/1/20] gave out pooled object: 
>org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@38d6f7
> [Company] XAException: tx=XidImpl [FormatId=257, GlobalId=raphael.frontwire.com//0, 
>BranchQual=] errorCode=XA_UNKNOWN(0)
> [Company] javax.transaction.xa.XAException: Rollback failed: Communication link 
>failure: java.io.IOException
> [Company]     at 
>org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl.rollback(XAResourceImpl.java:219)
> [Company]     at org.jboss.tm.TxCapsule.rollbackResources(TxCapsule.java:1557)
> [Company]     at org.jboss.tm.TxCapsule.rollback(TxCapsule.java:412)
> [Company]     at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:88)
> [Company]     at 
>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:307)
> [Company]     at 
>org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
> [Company]     at 
>org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:164)
> 
>


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to