I'm having trouble retrieving connections from my <local-tx-datasource> pool. Whenever a SQL connection exceeds the query-timeout, it seems to "break" that connection in the pool. I see the following line appear in my log:
| 08:53:07,949 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=utopia/50, BranchQual=, localId=50] timed out. status=STATUS_ACTIVE The next time I try to grab the connection via DataSource.getConnection() it throws the "Transaction is not active" error: 08:53:34,836 ERROR [STDERR] Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=utopia/50, BranchQual=, localId=50] | 08:53:34,836 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:287) | 08:53:34,836 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:368) | 08:53:34,836 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:797) | 08:53:34,837 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88) | ... This problem occurs with both MySQL and Oracle pooled connections. I've tried setting the <check-valid-connection> in the *-ds.xml file, but that doesn't seem to help. Any ideas what could be causing this? How can I reset the bad connections? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3923324#3923324 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3923324 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
