Any of you out there had any luck getting Transaction Recovery working with a MySQL XADatasource? My research leads me to believe that this is just not possible/supported with MySQL, but I wanted to check here before I do something as drastic as disabling tx recovery for all my xadatasource definitions.
From EAP5 documentation:
- Based on http://bugs.mysql.com/bug.php?id=12161, XA transaction recovery does not appear to be possible using MySQL. This is scheduled to be addressed in MySQL 6.1. See also JBPAPP-2576 in the release notes for JBoss Enterprise Application Platform 5.
Anyone else run into this issue?
Sorry I didn't see this message on time, maybe I don't get emails when discussions are moved here...
Anyway, that MySQL issue affects all application servers, it means recovery will work if MySQL crashes, but not if the transaction manager crashes.
I would suggest trying your app with PostGres as that does seem to work for recovery.