How insert row in table with INSTEAD OF TRIGGER on it?

Jericho · **Joined:** Thu Aug 25, 2005 3:14 am **Posts:** 19

Hi !

I working with MSSQL Server 2000 and have table with column Id as IDENTITY, and with INSTEAD OF INSERT trigger on this table. In class mapping file i mapped

Code:

      <id name="Id" column="Id" unsaved-value="-1">
         <generator class="identity" />
      </id>

when i save class in table Hibernate throw ADOException "Could not save object"
I think this excepion occured when after inserting row in table, HNIbernate trying to get Id of new row with query

Code:

SELECT SCOPE_IDENTITY()

and it return NULL as a really insert occurred in instead of trigger.

help pls. resolve this problem.