1 Reply Latest reply on Nov 7, 2002 11:50 AM by Noel Rocher

    Trans partially committed (BACK on TOP)

    Noel Rocher Apprentice

      Again with my transaction problem.

      This is a new way to explain my problem :

      =============================================
      Server "default"
      commit-option = B
      mssql2000-xa-service setted up


      trans-attribute = required
      SL_EJBA.addEJBA( ... )
      -------> trans-attribute = mandatory
      -------> CMP_EJBA.ejbCreate()
      -------> --------------> trans-attribute = mandatory
      -------> --------------> CMP_EJBCounter.getNextValue()
      -------> --------------> this add 1 to the "value"
      -------> --------------> column of the
      -------> --------------> Counter table.
      -------> <-------------- No problem
      -------> ...
      -------> throw Exception (from database)
      <--------
      ...

      throw Exception

      ================================================

      At the en of the SL_EJBA method call, the Counter table is updated !


      I tried the <sync-on-commit-only> option to true for the
      CMP 2.0 EJB conf (standardjboss.xml file) but there's no change.

      for the stateless configuration : only the call-loging option is available.


      The debug messages only show that there's an SQL update request
      that updates 1 Row after the exception.

      As we say in french : "je suis dans le brouillard !"

      Any help ?

      Noel