I have a bit of an interesting problem. I’m working on a what is a somewhat legacy system and encountered the following error trying to persist a new record into a specific table:
Cannot insert explicit value for identity column in table ‘Table_Name’ when IDENTITY_INSERT is set to OFF.
I believe I found the root of the problem, what I believe is a limitation of hibernate, but a confirmation would be nice to ensure I’m not doing anything incorrectly.
The SQL Server table I’m working with looks something like this:
ID - Int, primary key
Qty - Decimal
Price - Decimal
Order_Sequence - Int, identity (+1)
Because Order_Sequence is an identity and not the primary key, hibernate does not accept the insert. I found this brief document that may confirm this:
I tried marking Order_Sequence with @GeneratedValue and @GeneratedValue(strategy=“IDENTITY”) for but the error still occurs. Also setting IDENTITY_INSERT to ON before the inserting does not work.
Can someone confirm this is a limitation?