Discussions

EJB programming & troubleshooting: Oracle JDBC XA Driver with WLS 7.0 problem

  1. Oracle JDBC XA Driver with WLS 7.0 problem (1 messages)

    All,

    We are using EJB2.0 along with EJB-QL embided in the entitiy, when using with Oracle JDBC XA driver, throwing exception shown below and rolling back the transaction.

    java.sql.SQLException: ORA-02044: transaction manager login denied: transaction in progress
    ORA-06512: at "SYS.JAVA_XA", line 0
    ORA-06512: at line 1

            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
            at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
  2. Here's the text re: the error via oerr (Oracle's Unix utility)

    02044, 00000, "transaction manager login denied: transaction in progress"
    // *Cause: a remote transaction manager tried to log in while a distributed
    // transaction is in progress.
    // *Action: end the current transaction (this is a protocol error from a
    // remote transaction manager)

    Looks like you may have an uncommited transaction. I would recommend that you pose the same question on Oracle's technet discussion forums: otn.oracle.com