I am trying to update an Oracle table and a JMS mesage in one global transaction, using XA. I am running Personal Oracle 8 on NT. The Application is running Successfully without OptimizeIt Profiller tool. if
i am using Weblogic Server with OptimizeIt Profiller then i am facing OracleXAException.

<Dec 30, 2003 12:16:04 PM IST> <Error> <EJB> <Exception during commit of transac
tion Name=[EJB com.dstsystems.concorde.business.cafm.session.inte rfaces.CafmInte
rfacesServiceEJB.createBillingInput(java.util.Coll ection)],Xid=1018:0a7980ab493a
fd3a(6371213),Status=Rolled back. [Reason=oracle.jdbc.xa.OracleXAException],numR
epliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=135,seconds left=10,Se
rverResourceInfo[JMS_defaultStore]=(state=rolledback,assigned=cafmServer),Server
ResourceInfo[CdbbConnectionPool]=(state=rolledback,assigned=cafmServer),ServerRe
sourceInfo[AuthConnectionPool]=(state=rolledback,assigned=cafmServer),ServerReso
urceInfo[GlobalConnectionPool]=(state=rolledback,assigned=cafmServer),ServerReso
urceInfo[EAMConnection]=(state=rolledback,assigned=cafmServer),SCInfo[cafm+cafmS
erver]=(state=rolledback),properties=({ISOLATION LEVEL=2, weblogic.transaction.n
ame=[EJB com.dstsystems.concorde.business.cafm.session.inte rfaces.CafmInterfaces
ServiceEJB.createBillingInput(java.util.Collection )]}),OwnerTransactionManager=S
erverTM[ServerCoordinatorDescriptor=(CoordinatorURL=cafmSe rver+172.19.16.33:9009
+cafm+, Resources={})],CoordinatorURL=cafmServer+172.19.16.33:9009+cafm+ ): oracl
e.jdbc.xa.OracleXAException
at oracle.jdbc.xa.client.OracleXAResource.prepare(Ora cleXAResource.java:
747)
at weblogic.jdbc.jta.VendorXAResource.prepare(VendorX AResource.java:61)
at weblogic.jdbc.jta.DataSource.prepare(DataSource.ja va:708)
at weblogic.transaction.internal.ServerResourceInfo.p repare(ServerResour
ceInfo.java:1182)
at weblogic.transaction.internal.ServerResourceInfo.p repare(ServerResour
ceInfo.java:426)
at weblogic.transaction.internal.ServerSCInfo.startPr epare(ServerSCInfo.
java:189)
at weblogic.transaction.internal.ServerTransactionImp l.localPrepare(Serv
erTransactionImpl.java:1821)
at weblogic.transaction.internal.ServerTransactionImp l.globalPrepare(Ser
verTransactionImpl.java:1545)
at weblogic.transaction.internal.ServerTransactionImp l.internalCommit(Se
rverTransactionImpl.java:226)
at weblogic.transaction.internal.ServerTransactionImp l.commit(ServerTran
sactionImpl.java:177)
at weblogic.ejb20.internal.BaseEJBObject.postInvoke(B aseEJBObject.java:2
84)
at com.dstsystems.concorde.business.cafm.session.inte rfaces.CafmInterfac
esServiceEJB_qo999m_EOImpl.createBillingInput(Cafm InterfacesServiceEJB_qo999m_EO
Impl.java:148)
at com.dstsystems.concorde.business.cafm.messageDrive n.interfaces.CafmIn
terfacesCreateBillingInputPrimaryMDB.callService(C afmInterfacesCreateBillingInpu
tPrimaryMDB.java:83)
at com.dstsystems.concorde.business.cafm.messageDrive n.interfaces.CafmIn
terfacesBaseMDB.onMessage(CafmInterfacesBaseMDB.ja va:135)
at weblogic.ejb20.internal.MDListener.execute(MDListe ner.java:272)
at weblogic.ejb20.internal.MDListener.onMessage(MDLis tener.java:220)
at weblogic.jms.client.JMSSession.onMessage(JMSSessio n.java:1873)
at weblogic.jms.client.JMSSession.execute(JMSSession. java:1822)
at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:143)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:129)
--------------- nested within: ------------------
weblogic.transaction.RollbackException: Could not prepare resource 'AuthConnecti
onPool - with nested exception:
[oracle.jdbc.xa.OracleXAException]
at weblogic.transaction.internal.TransactionImpl.thro wRollbackException(
TransactionImpl.java:1481)
at weblogic.transaction.internal.ServerTransactionImp l.internalCommit(Se
rverTransactionImpl.java:267)
at weblogic.transaction.internal.ServerTransactionImp l.commit(ServerTran
sactionImpl.java:177)
at weblogic.ejb20.internal.BaseEJBObject.postInvoke(B aseEJBObject.java:2
84)
at com.dstsystems.concorde.business.cafm.session.inte rfaces.CafmInterfac
esServiceEJB_qo999m_EOImpl.createBillingInput(Cafm InterfacesServiceEJB_qo999m_EO
Impl.java:148)
at com.dstsystems.concorde.business.cafm.messageDrive n.interfaces.CafmIn
terfacesCreateBillingInputPrimaryMDB.callService(C afmInterfacesCreateBillingInpu
tPrimaryMDB.java:83)
at com.dstsystems.concorde.business.cafm.messageDrive n.interfaces.CafmIn
terfacesBaseMDB.onMessage(CafmInterfacesBaseMDB.ja va:135)
at weblogic.ejb20.internal.MDListener.execute(MDListe ner.java:272)
at weblogic.ejb20.internal.MDListener.onMessage(MDLis tener.java:220)
at weblogic.jms.client.JMSSession.onMessage(JMSSessio n.java:1873)
at weblogic.jms.client.JMSSession.execute(JMSSession. java:1822)
at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:143)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:129)


Does anyone know help me ASAP.