1 Reply Latest reply on Jun 6, 2011 4:50 AM by rayon

XA DataSource Warning on AS 6

lholmquist May 25, 2011 11:32 AM

I'm in the process of migrating my 2 jboss instances(4.2.3 and 5.0.1) to AS 6 Final. There are a couple projects that required the datasources to be xa-datasources. The apps seem to be working fine but every minute or so i get the warning below. I don't get this on the 4.2.3 and 5.0.1 versions. Not sure if this is something i should worry about

11:25:23,107 WARN  [jta] ARJUNA-16027 Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR: javax.transaction.xa.XAException
    at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:703) [:Oracle JDBC Driver version - "11.1.0.6.0-Production"]
    at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.recover(XAManagedConnection.java:294) [:6.0.0.Final]
    at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecovery(XARecoveryModule.java:468) [:6.0.0.Final]
    at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.resourceInitiatedRecoveryForRecoveryHelpers(XARecoveryModule.java:436) [:6.0.0.Final]
    at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkSecondPass(XARecoveryModule.java:155) [:6.0.0.Final]
    at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:789) [:6.0.0.Final]
    at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:371) [:6.0.0.Final]

 <xa-datasource>   
         <jndi-name>hdDataSource</jndi-name>
          <use-java-context>false</use-java-context>
          <track-connection-by-tx>true</track-connection-by-tx>
           <isSameRM-override-value>false</isSameRM-override-value>
           <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
            <xa-datasource-property name="URL">jdbc:oracle:thin:@***</xa-datasource-property>
            <xa-datasource-property name="User">***</xa-datasource-property>
           <xa-datasource-property name="Password">***</xa-datasource-property>
            <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
               <no-tx-separate-pools/>
        </xa-datasource>

The jar in my AS lib folder is ojdbc6.jar that i got from the Oracle 11gR1 install

1. Re: XA DataSource Warning on AS 6

rayon Jun 6, 2011 4:50 AM (in response to lholmquist)

> at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:702)
Have a look at http://docs.codehaus.org/display/BTM/FAQ#FAQ-WhyisOraclethrowingaXAExceptionduringinitializationofmydatasource%3F.
Not exactly the line of code but maybe usefull:

---- quote---
Oracle resources can only be recovered when the configured user has these privileges:
grant select on sys.dba_pending_transactions to myUser;
grant select on sys.pending_trans$ to myUser;
grant select on sys.dba_2pc_pending to myUser;
grant execute on sys.dbms_system to myUser;
---- quote---
Actions