2 Replies Latest reply on Nov 4, 2002 2:44 PM by Luis JB Soeiro

    How to find out what is behind a transaction Exception?

    Luis JB Soeiro Newbie

      Hello All

      Is there any way (log file, message, debug code, whatever) fo find out the real cause for a transaction Excpetion at commit time?

      I have a complex scenario in which every now and then we are faced with this kind of erros:

      2002-11-01 14:15:42,886 WARN [org.jboss.tm.TxCapsule] XAException: tx=XidImpl [FormatId=257, GlobalId=R1SV//10, BranchQual=] errorCode=XA_UNKNOWN(0)
      javax.transaction.xa.XAException: could not commit local txjavax.resource.ResourceException: SQLException
      at org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConnectionEventListener.commit(LocalTxConnectionManager.java:563)
      ...

      The problem is that we have no clue to the reason of the failure. We now have a setup with about 68 Session Beans plus 62 Entity Beans, all using CMT, CMP and CMR. It is just impossible to find out what went wrong without at least a clue...Isn't there a message somewhere of the kind "invalid column name, unique error, etc"?

      Thanks for your help,

      Luis JB Soeiro