General J2EE: XAException occuring in websphere6.1... Help pls

  1. I am getting an XAException while preparing a insert stmt.. I am using JTA for handling distributed txns. It throws error on commit(usertransaction.commit()). I am using websphere6.1, Oracle 10g. Googling i found that it is req to run initxa.sql i did that.. Is ter anthing else i have to.. Including the logs for u.


     00000024 WSRdbXaResour E   DSRA0304E:  XAException occurred. XAException contents and details are:
    The XA Error is            : -3
    The XA Error message is    : A resource manager error has occured in the transaction branch.
    The Oracle Error code is   : 17410
    The Oracle Error message is: Internal XA Error
    The cause is               : null.
    [7/15/10 16:35:32:156 IST] 00000024 WSRdbXaResour E   DSRA0302E:  XAException occurred.  Error code is: XAER_RMERR (-3).  Exception is: <null>

    00000024 XATransaction E   J2CA0027E: An exception occurred while invoking commit on an XA Resource Adapter from dataSource jdbc/myDataSource, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54), data(00000129d5c7c1a4000000010000000867432b1eb9280ba09ef9aeeb675893c2aaa0ea0200000129d5c7c1a4000000010000000867432b1eb9280ba09ef9aeeb675893c2aaa0ea02000000010000000000000000000000000001)}: oracle.jdbc.xa.OracleXAException
     at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:962)
     at oracle.jdbc.xa.client.OracleXAResource.commit(OracleXAResource.java:459)
     at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.commit(WSRdbXaResourceImpl.java:275)
     at com.ibm.ejs.j2c.XATransactionWrapper.commit(XATransactionWrapper.java:462)
     at com.ibm.ws.Transaction.JTA.JTAXAResourceImpl.commit(JTAXAResourceImpl.java:274)
     at com.ibm.ws.Transaction.JTA.RegisteredResources.deliverOutcome(RegisteredResources.java:1837)
     at com.ibm.ws.Transaction.JTA.RegisteredResources.distributeOutcome(RegisteredResources.java:2334)
     at com.ibm.ws.Transaction.JTA.RegisteredResources.distributeCommit(RegisteredResources.java:2655)
     at com.ibm.ws.Transaction.JTA.TransactionImpl.internalCommit(TransactionImpl.java:2616)
     at com.ibm.ws.Transaction.JTA.TransactionImpl.stage2CommitProcessing(TransactionImpl.java:1701)
     at com.ibm.ws.Transaction.JTA.TransactionImpl.processCommit(TransactionImpl.java:1581)
     at com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:1512)
     at com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:237)
     at com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:162)
     at com.ibm.ws.Transaction.JTA.UserTransactionImpl.commit(UserTransactionImpl.java:285)

  2. This is a DB issue. Pls refer the following;


  3. Thanks yaar for the reply.. I did find it to be a DB issue. I am using JTA userTransaction to mark the transaction boundaries.. On commit i m getting this error. I browsed oracle.com and followed the steps mentioned; took the local transaction id from pending_trans$ and did a force commit also purged the txn using DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY. Still after doing this when i check the particular flow i am facing the same issue. Could u suggest what has to be done to fix this.. tis in local setup.. I dont have a DBA to sort out..