Hi,

I am using NHibernate 1.0.2 with existing database schema (Sybase) that has triggers. While doing a simple update operation that should modify ONE row I get the following exception message -

[NHibernate.HibernateException] {NHibernate.HibernateException}

{"SQL insert, update or delete failed (expected affected row count: 1, actual affected row count: 25). Possible causes: the row was modified or deleted by another user, or a trigger is reporting misleading row count." }

In this case there is a trigger that is indeed modifying 25 rows. I cannot disable/remove this trigger - and it does need to do its work and modify 25 rows. So how do I use NHibernate to do update with this database?

Having checked the NHibernate source - EntityPersister.Update() always checks to make sure that the number of expected updated rows matches the actual updated rows. So how do I use NHibernate in this situation?

Thanks

AbiMan

On SQL Server the solutiion is to have SET NOCOUNT ON in the triggers.
I think there is something similar in Sybase as well.

cheers,
Radu

Thanks,

This fixes the problem. But I cannot add the SET NOCOUNT ON in all of the triggers. Is there a way to tell NHibernate to ignore the update count returned by the database?

Unfortunately I cannot use the set nocount solution becuase I am querying a 3rd party database and as such am not allowed to alter their triggers.

Is there no other way to stop this problem?

Which driver are you using? Check the driver documentation, it should have some flag to neglect the update count.

-abiman

I am facing the same problem right now I dont know how to solve it.

If I set NOCOUNT on in the triggers the SaveOrUpdate method works but when I execute commit transaction ADO.NET raised an excpetion informing that it was expecting 2 rows ( for example ) but only one was returned.

If I set NOCOUNT off in the triggers the opposite happens and the SaveOrUpdate method NHibernate raises a row count misleading exception.

Are you having the same problem ?

How can I solve the problema without removing triggers ?

t+