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