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

    Oracle XA Distributed Transaction

    634987

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

        • 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
          reconnected?
          Good luck,
          Joe