If you look closely, you will find that the mysql "xa" is a fake xa wrapper with no xa semantics. I think it's simpler to stick with the local wrapper where we know the sharing is appropriate within one transaction.
I just wondered if LocalTransaction means that if I have all my EntityBeans in one DBMS that transactions are fully supported.
As long as you don't include other things like transacted jms messages in the same transaction you will be fine. If you only use mysql local transactions are adequate.
> If you look closely, you will find that the mysql
> "xa" is a fake xa wrapper with no xa semantics.
Yes, as MySQL doesn't support XA (yet, I'm pushing for it). This XADataSource implementation was meant to be used where there were no other options, which is not the case in JBoss.