Fixed bug of Oracle 11g JDBC driver under JBoss AS 7.1.1
I got the following exception when using Oracle as a database in my application. The warning occurs randomly, even when the server starts. If the database is empty when it comes up it warns about db popping and generating for some tables.
I don't know what's going on here.
Thank you in advance
4:27:47,263 WARN [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR: javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:709)
at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.recover(XAManagedConnection.java:358)
at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.recover(XAResourceWrapperImpl.java:162)
at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecovery(XARecoveryModule.java:503) [jbossjts-4.16.2.Final.jar:]
at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.resourceInitiatedRecoveryForRecoveryHelpers(XARecoveryModule.java:471) [jbossjts-4.16.2.Final.jar:]
at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.bottomUpRecovery(XARecoveryModule.java:385) [jbossjts-4.16.2.Final.jar:]
at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkSecondPass(XARecoveryModule.java:166) [jbossjts-4.16.2.Final.jar:]
at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:789) [jbossjts-4.16.2.Final.jar:]
at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:371) [jbossjts-4.16.2.Final.jar:]
+3
source to share
2 answers
I found a way to fix this.
Based on this thread , I did the following as admin:
GRANT SELECT ON sys.dba_pending_transactions TO carlos;
GRANT SELECT ON sys.pending_trans$ TO carlos;
GRANT SELECT ON sys.dba_2pc_pending TO carlos;
GRANT EXECUTE ON sys.dbms_system TO carlos;
The warning disappears, but I don't know exactly what the consequences are.
+4
source to share
See http://database-diva.com/blog/?p=6 for security issues related to execute permissions on sys.dbms_system .
+3
source to share