2 Replies Latest reply on Aug 10, 2002 12:26 PM by dsundstrom

    Transaction Warnings with Oracle 9.0.1

    markc

      New to JBoss and Oracle. I am using JBoss 2.4.4 with Jetty, and the Oracle OCI driver. Have an MDB using CMT. What is the meaning of the following error?

      [WARN,TxCapsule] XAException: tx=XidImpl [FormatId=257, GlobalId=orion//550, BranchQual=] errorCode=XAER_RMERR
      oracle.jdbc.xa.OracleXAException
      at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:659)
      at oracle.jdbc.xa.client.OracleXAResource.commit(OracleXAResource.java:404)
      at org.jboss.tm.TxCapsule.commitResources(TxCapsule.java:1490)
      at org.jboss.tm.TxCapsule.commit(TxCapsule.java:340)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76)
      at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:314)
      at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:565)
      at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:376)
      at org.jboss.mq.SpySession.run(SpySession.java:248)
      at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:172)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:728)
      at java.lang.Thread.run(Thread.java:484)

      It is usually the precursor to a set of varying Oracle errors like: [ERROR,Default] java.sql.SQLException: ORA-02044: transaction manager login denied: transaction in progress

      Thanks in advance.

        • 1. Re: Transaction Warnings with Oracle 9.0.1
          timfox

          Hi -
          I am getting this problem now.
          Did you ever get a solution??

          • 2. Re: Transaction Warnings with Oracle 9.0.1
            dsundstrom

            I suggest you ask this in the JCA forum. You should also upgrade to 2.4.8, which sould be out today, as it fixes a lot of the XA problems. One thing to note is Oracle does not follow the XA spec and every point release of the driver breaks the spec in a new and interesting way, so you may still have problems. I'm not the expert on this, but this is what I have heard on the lists.