1 Reply Latest reply on Feb 11, 2009 11:40 AM by mazz

    XAException.XAER_RMERR

    nsyed4

      I read the following blogs on XA:

      http://management-platform.blogspot.com/2008/11/transaction-recovery-in-jbossas.html
      and
      http://www.jboss.org/index.html?module=bb&op=viewtopic&t=14613

      I am understanding from them that the user performing the transactions must have the following privileges if using Oracle 10g and the first four of these are mandatory:

      GRANT SELECT ON sys.dba_pending_transactions TO db_user;
      GRANT SELECT ON sys.pending_trans$ TO db_user;
      GRANT SELECT ON sys.dba_2pc_pending TO db_user;
      GRANT EXECUTE ON sys.dbms_system TO db_user;
      GRANT SELECT ON v$xatrans$ TO db_user;
      


      However, the DBA's don't want to use XA for Transaction recovery.

      How critical is the following warning to the working of the jopr solution?


      [com.arjuna.ats.internal.jta.recovery.xarecovery1] Local XARecoveryModule.xaRecovery got XA exception javax.transaction.xa.XAException, XAException.XAER_RMERR


      Thanks.


        • 1. Re: XAException.XAER_RMERR
          mazz

          I could give a snippy reply like those from Mark Little (just kidding mark :), but - as he would say, why bother with transactions if you do not want to recover from failed ones? That forum post you listed ( http://www.jboss.org/index.html?module=bb&op=viewtopic&t=146138 ) goes through all the gory details, as does that blog post of mine.

          That said, this error doesn't affect the normal runtime - its saying, "I can't ask the database for a list of tx's that failed because I have not been given permission to see them". If you do get a failed yet recoverable transaction in the database, however, there is no way for you to clean it up.