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

mohankishore (JIRA) jira-events at lists.jboss.org
Sat May 2 00:27:46 EDT 2009


     [ https://jira.jboss.org/jira/browse/JBTM-541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

mohankishore updated JBTM-541:
------------------------------

    Attachment: ConnectionImple.patch


> 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
>
>         Attachments: ConnectionImple.patch, TransactionImple.patch
>
>
> 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 for ConnectionImple that fixes the logic in the close() method. Also has a couple of jdk6 methods that allow the client to access the underlying native conneciton..
>  Am also adding a patch for the TransactionImple - which ensures that we call XAResource.rollback() - cleaning up the XAC for subsequent reuse.

-- 
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

        



More information about the jbossts-issues mailing list