Hi

Using MSSQL and nhibernate 2.2

I'm trying to persist a transient instance using the Save() method.

I get the following DAOException:

Cannot insert explicit value for identity column in table 'DriverCategory' when IDENTITY_INSERT is set to OFF.

I am using the "native" generator module in the mapping for the object I'm trying to persist.

Is there a setting I should change on the SQL server?

Can someone shed some light?

Thanks

It is likely a mapping error. Use the SQL Profiler to see what is actually sent to SQL Server. Please post mapping file(s) if you need further assistance.

Karlchu, you were right.
It was due to a mapping error in a recursive association.

Thank you for pointing that possibilty out. I found it a rather awkward error message.