1 Reply Latest reply on Mar 2, 2003 7:38 AM by raghavendra kedilaya

    sybase running stored procedure

    raghavendra kedilaya Newbie

      Dear friends

      I am facing problem while calling stored procedure in stateful session bean.I could get around the problem "SET CHAINED ...." by using setAutoCommit(false)
      in my code.

      Following error has occured.

      [STDOUT] connection is obtained in executeprocedure method
      [STDOUT] callablestatement is created
      [STDOUT] parameters are set
      [STDOUT] Exception occured


      javax.transaction.xa.XAException: wrong xid in commit: expected: null, got: XidImpl [FormatId=257, GlobalId=xxx//29, BranchQual=1]
      at org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConnectionEventListener.commit(LocalTxConnectionManager.java:548)
      at org.jboss.tm.TxCapsule.commitResources(TxCapsule.java:1714)
      at org.jboss.tm.TxCapsule.commit(TxCapsule.java:393)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:201)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
      at org.jboss.ejb.StatefulSessionContainer.invoke(StatefulSessionContainer.java:380)
      at org.jboss.ejb.Container.invoke(Container.java:712)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98)
      at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:102)
      at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
      at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
      at org.jboss.proxy.ejb.StatefulSessionInterceptor.invoke(StatefulSessionInterceptor.java:117)
      at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)