In order to solve my problems with jboss and UserTransactions I also tried some oracle XA settings with jboss 3.0.0beta. I packed everything of interest in the attached zip-file. I think the settings are not too bad, however they don't work correctly.
I will start a new thread "Oracle and UserTransactions" tomorrow in order to discuss everything I could find out about my problem with UserTransactions (not only with Oracle but also with PostgreSQL and the Hypersonic DB).
I hope the attached files can help you a bit.
Are you interested in settings for SQl Server? I took your template and I think I have XA working with SQL Server 2000, Opta2000 driver and JBoss 3.0 HEAD.
I've got two EJBs in two jars coordinating SQL ops - that a sufficient test?
OK I've just sent it (attached here as well, just in case). You'll get a mail from my main email address, not the one I'm registered under here (can't change the address in the forums!)
Could u send an example for Mysql please.