0 Replies Latest reply on Jul 16, 2003 6:51 AM by s_thom

    Oracle LocalTX issue

    s_thom Newbie

      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).

      Steve