I'd like to get more information regarding the use of local-tx-datasource versus an xa-datasource. Our applicaiton uses a single database with no distributed work. We have implementations with both MySql (which has no xa support) and sql server. Should I be using the local or xa datasource? Does it really matter for our application?
You only need to use XA if there are other branches in the transaction,
XA gives you two phase commit.