General J2EE: Hibernate: Update Table with Triggers

  1. Hibernate: Update Table with Triggers (2 messages)

    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

    Threaded Messages (2)

  2. Set NOCOUNT[ Go to top ]

    For SQLSERVER : In the trigger add "SET NOCOUNT ON".
  3. Re: Set NOCOUNT[ Go to top ]

    Did you get any solution to this????