Update: I just noticed this warning -- "Prepare called on a local tx. Use of lo cal transactions on a jta transaction with more than one branch may result in in consistent data in some cases of failure."
What does it mean?
Regarding your scenario, you have to use XA-transactions, as well as configure your datasource as XA datasource. Please have a look at jboss wiki for further inforamation.
Hope this helps,
It does, thank you for pointing me in the right direction!