[jbossts-issues] [JBoss JIRA] Closed: (JBTM-401) Resource Leakage in Transactional Driver

Resource Leakage in Transactional Driver ---------------------------------------- Key: JBTM-401 URL: https://jira.jboss.org/jira/browse/JBTM-401 Project: JBoss Transaction Manager Issue Type: Bug Security Level: Public(Everyone can see) Components: JTA Implementation Affects Versions: 4.4.CR1 Environment: Standalone JTA build Reporter: Michael Musgrove Assignee: Michael Musgrove Fix For: 4.4.0.GA Use the Transactional Driver to get a JDBC connection (this returns a ConnectionImple which wraps the connection to the real resource and enlists/delists it with transactions). After running about 500 transactions the underlying resource throws an error reporting "Too many connections" (I tried this on Derby and MySql XA drivers). The real connection is implemented by RecoverableXAConnection - when a transaction completes the reference to the real connection is nulled (and therefore not closed) so on the next transaction a new connection is obtained so the resource manager eventually runs out of connections.