users@genericjmsra.java.net

XAException while connecting Generic JMS RA 2.0 with Oracle AQ

From: Sri Sri <mesri09_at_gmail.com>
Date: Tue, 19 Aug 2008 12:11:44 +0530

Hi,

Following is my scenario:-

I have configured Generic JMS RA 2.0 with Oracle AQ (on 10G Database) as the
JMS provider. I have a container managed MDB with "Required" transaction
consuming from queue OutboundQueue and from within the MDB looks up Queue
DeadLetterQueue and publishes to DeadLetterQueue. When it is publishing to
Queue DeadLetterQueue, I am getting the following exception and the message
is getting rolled back to Queue OutboundQueue. There are 2 Connector pools
for both the queues (I have tried using a single pool also as both the
queues are on the same schema in the database)

[#|2008-08-19T11:27:21.632+0530|WARNING|sun-appserver-ee8.1_02|javax.enterprise.system.core.transaction|_ThreadID=14;|JTS5041
: The resource manager is doing work outside a global transaction
oracle.jdbc.xa.OracleXAException
        at
oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1223)
        at
oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:318)
        at oracle.jms.AQjmsXAResource.start(AQjmsXAResource.java:440)
        at
com.sun.genericra.outbound.XAResourceProxy.start(XAResourceProxy.java:244)
        at
com.sun.enterprise.resource.XAResourceWrapper.start(XAResourceWrapper.java:98)
        at
com.sun.jts.jta.TransactionState.startAssociation(TransactionState.java:265)
        at
com.sun.jts.jta.TransactionImpl.enlistResource(TransactionImpl.java:181)
        at
com.sun.enterprise.distributedtx.J2EETransaction.enlistResource(J2EETransaction.java:397)
        at
com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.enlistResource(J2EETransactionManagerImpl.java:317)
        at
com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.enlistResource(J2EETransactionManagerOpt.java:114)
        at
com.sun.enterprise.resource.ResourceManagerImpl.registerResource(ResourceManagerImpl.java:117)

I have attached the server.log, the screenshots of configuration on SUN
Application server 8.1_02. Has anyone faced a similar problem, please help
me solve the above issue.

Any more information required, please let me know.

Cheers