NHibernate 'IdentifierGenerationException' on an Update trigger
Posted
by Jan Jongboom
on Stack Overflow
See other posts from Stack Overflow
or by Jan Jongboom
Published on 2010-03-15T11:13:17Z
Indexed on
2010/03/15
11:19 UTC
Read the original article
Hit count: 271
In my database I have an id column defined as [autonumber] [int] IDENTITY(1,1) NOT NULL
which is mapped in my .hbm.xml like:
<id name="Id" column="autonumber" type="int">
<generator class="identity" />
</id>
When calling session.Save()
updates are successful committed to the database.
When adding a versioning trigger I however get the error this id generator generates Int64, Int32, Int16
of type IdentifierGenerationException
.
The trigger is defined as:
ALTER TRIGGER [dbo].[CatchUpdates_NVM_FDK_Kenmerken]
ON [dbo].[NVM_FDK_Kenmerken]
INSTEAD OF UPDATE
AS
BEGIN
SET NOCOUNT ON
UPDATE NVM_FDK_Kenmerken SET idIsActive = 0 WHERE internalId IN (SELECT internalId FROM INSERTED)
INSERT INTO dbo.NVM_FDK_Kenmerken
( vestigingNummer , internalId , someOtherColumns, dateInserted, idIsActive )
SELECT vestigingNummer, internalId, someOtherColumns, GETDATE(), 1
FROM INSERTED
END
What am I doing wrong here? When doing manual updates everything works just fine and as expected.
© Stack Overflow or respective owner