I use NHibernate V 0.9 and I have a table with a trigger and I get the following error message when saving an object with NHibernate to that table:

I understand the errormessage, but I don't think that this error should appear, because the trigger should do its job. So does this mean I can't save an object to this table, or is there a possibility to tell NHibernate to ignore the rowcount?

Thanks, Rainer.

There should be a way to tell the trigger to report the right row count (1 row, if it worked). I'm not sure if just using "rowcount > 1" instead of "rowcount == 1" comparison is safe enough.

You need to put the following command on the first line of your triggers.



You can then optionally (recommended) add to the end of each trigger

Thanks alot! That was it :D