[jbossts-issues] [JBoss JIRA] Created: (JBTM-541) Enhance support for MySQL XA connections

Enhance support for MySQL XA connections ---------------------------------------- Key: JBTM-541 URL: https://jira.jboss.org/jira/browse/JBTM-541 Project: JBoss Transaction Manager Issue Type: Patch Security Level: Public (Everyone can see) Components: JTA Affects Versions: 4.6.1 Reporter: mohankishore Fix For: 4.6.1.CP01 As generally accepted, the MySQL support for XA is somewhat broken. If you do the following: - begin a transaction - get an XAConnection from MySQL, - get a connection from the XAC - do some operations, - close the connection - get another connection from XAC - try to do some operations -> MYSQL throws an exception stating that it does not support a XA START RESUME But, this leads to certain undesirable behavior inside the JBOSS JTA codebase. It is resulting in not calling XAC.close(). We are using a custom pool for limiting the number of XAConnections we create - which gets maxed out because of this. Am attaching a patch that seems to help out. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira