1 Reply Latest reply on Apr 3, 2013 10:13 PM by Joe Weinstein-Oracle

    Oracle XA Distributed Transaction


      Does Oracle alone support global transaction management using multiple oracle databases for Standalone applications? (or is an app server also required for the same)?

        • 1. Re: Oracle XA Distributed Transaction
          Joe Weinstein-Oracle
          You can do it on your own, with just the JDBC driver, if you get
          XA connections and their XA resources, and do your own start(),
          prepare() and commit() etc. The tricky bit is to do the right thing
          in the failure and recovery cases, such as if your last of three
          commit() calls fails with an I/O exception and you've lost DBMS/net
          connectivity. Did it commit or not? What do you do when you get
          Good luck,