ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  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?


Krishna