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


    nsyed4 Newbie

      I read the following blogs on XA:


      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


        • 1. Re: XAException.XAER_RMERR
          mazz Master

          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.