0 Replies Latest reply on Oct 16, 2002 6:41 PM by tvaananen

    Triggers and update row count

    tvaananen


      Hi,

      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.

      --
      Tero