I get the following warning when I perform an SQL insert and a JMS post within a single UserTransaction.
org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource] Prepare called on a local tx. Use of local transactions on a jta transaction with more than one branch may result in inconsistent data in some cases of failure.
The strange thing is though (if you take a look at my code example) if I call rollback on my UserTransaction both the JMS message & the SQL is correctly rolled back. So why am I getting the message when everything appears to work as it should?
I am using an Oracle datasource (local-tx-datasource).