1 Reply Latest reply on Oct 10, 2008 2:30 AM by Vicky Kak

    Problem with XA and local transactions

    Claus Hausberger Newbie

      Hello

      I have the following situation:

      Two Oracle (10g) database schemas (completely seperated with different username / password).

      I need a transaction over both schemas. To realize this I declared two <xa-datasource> datasources, one for each schema.

      When I use the tranaction everything seems to work just fine, but I find this warning in the log file:

      "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"

      I am new to XA transactions, so maybe my whole setup is wrong.
      Any idea what the problem could be here?

      Claus

      P.S. I use Spring for transaction configuration (rg.springframework.transaction.jta.JtaTransactionManager und declarative configuration via Spring AOP/AspectJ of the transactions).