Hibernate Your Data
Subject:   Hibernate: Update Table with Triggers
Date:   2006-10-08 12:13:30
From:   Krishna_Pothula
Hibernate and SQL Server.

I am using Hibernate to select/insert/update operations on a Table. This table has a trigger defined on it that is triggered on every add/modify/delete. All this trigger does is check the data being inserted and update the Audit tables.

When I run an update sql is the SQL command window I get ...
0 rows updates
1 row updated
1 row updated

But when I update a row using Hibernate, I get an error saying something like Expecting 1 row instead of 0. We tried options like no select before update... but none worked.

Does this mean Hibernate does not work with Triggers ?
Did any one face this kind of problem?