I am using JBOSS 3.0.3 and SQL Server 2000. JBoss CMP seems to expect affected row count of exactly 1 when creating/updating entities. However, SQL Server might not return 1 when triggers are used to update rows in some other table, for example. The resulting count is 1 + (rows affected by triggers).
I was wondering if the count check has to be so stringent. Triggers would have been useful in my case.