Can MySQL fully support XA transactions?

[James Adams]

I am trying to use XA transactions with a MySQL database using Spring, Hibernate, OpenMQ, and Atomikos and there is apparently an insufficiency in the XA DataSource implementation (due to this http://dev.mysql.com/doc/refman/5.0/en/xa-restrictions.html) which prevents resumes from completing successfully.

See thisa thread for more information as far as error stack traces and configuration details: http://fogbugz.atomikos.com/default.asp?community.6.360.2

Can I use MySQL for XA transactions in this manner, or would using another approach (different TransactionManager, etc.) be a better idea?

I will eventually deploy in Glassfish, so should I try using the Glassfish JTA TransactionManager and hope that it works a little better with the MySQL XA Driver?

Thanks in advance for any suggestions.

--James