nhibernate update trigger gives exception

venkatparitala · **Joined:** Tue Dec 18, 2007 7:11 am **Posts:** 7

CREATE TRIGGER EMP_UPDATE ON EMP
FOR UPDATE
AS
IF UPDATE(ACTIVE_STATUS)
BEGIN
UPDATE EMP SET LAST_MODIFICATION_DATE = GETDATE()
FROM EMP
INNER JOIN INSERTED
ON EMP.id= EMP.id

END

giving exception because of two updations one by query and once by trigger.so count is 2 where as nhibernate expects 1.

SQL insert, update or delete failed (expected affected row count: 1, actual affected row count: 2). Possible causes: the row was modified or deleted by another user, or a trigger is reporting misleading row count. at NHibernate.Impl.NonBatchingBatcher.AddToBatch(Int32 expectedRowCount)

luedi · **Joined:** Tue Feb 21, 2006 9:50 am **Posts:** 107

You have to set "nocount on" / "nocount off" (see: http://jira.nhibernate.org/browse/NH-192)

Code:

CREATE TRIGGER EMP_UPDATE ON EMP
FOR UPDATE
AS
IF UPDATE(ACTIVE_STATUS)
BEGIN

set nocount on

UPDATE EMP SET LAST_MODIFICATION_DATE = GETDATE()
FROM EMP
INNER JOIN INSERTED
ON EMP.id= EMP.id

set nocount off

END

Regards
Klaus