Hi ,
Can anyone provide me more information on when the following Nhibernate Exception occurs.


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

One example: if update query looks like

UPDATE YourTable
SET [..]
WHERE Id = 1

But there is no row with Id = 1 in database. According to posts in the forum, it may happen when NHibernate is unable to correctly determine whether an object must be inserted or updated in database. (NHIbernate thinks that he must update an object but in realuity the object needs to be inserted).

Thanks,

In my case I have three tables .Two of these tables have a many to many relationship between them which is maintained by a link table(fourthttable).
The third table has foreign key to one of the two tables mentiones earlier.

Now when i insert data into theses three tables one after another using nhibernate.the records are properly entered..But when i want to delete all these tables i get the "INSERT UPDATE FAILED' exception.

Further i would like to add that i do not have any triggers in the database.

What could be the problem?Any suggestions ?

Might it be that NHibernate tries to delete from relation table several times? It would be propably good if You can create an test case and post it to Jira

Gert