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

[mohankishore (JIRA)]

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