Using the Increment Generator I can save an obejct with an int key with SQLServer -
However when I flush I get the following errorjava.sql.SQLException: Cannot insert explicit value for identity column in table 'Products' when IDENTITY_INSERT is set to OFF
I thnk that the DB is supposed to generate an ID but how do I declare to use this capability.



Caused by: java.sql.SQLException: Cannot insert explicit value for identity column in table 'Products' when IDENTITY_INSERT is set to OFF.
at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:85)
at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:99)
at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:709)
at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:231)
at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:214)
at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:180)
at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:235)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468)

<class >
<id unsaved-value="0" column="id" type="int" name="id">
<generator class="identity"/>
</id>
<property ....>
......
</class>

guenz

java.lang.RuntimeException: net.sf.hibernate.MappingException: Dialect does not support identity key generation

I am using SQLServer 2000

You have not set the right dialect in your configuration.

i'm using sql server 2000 too and it works fine.

which Dialect - and I am talking to the northwind database

net.sf.hibernate.dialect.SQLServerDialect

I too am using MS Sqlserver 2000 and Hibernate 2.1.8 and am getting the same error message:


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




I am using the above dialect and also this code



I have the SESSION_ID column set to Identity=Yes on the Sqlserver database table, so there should not be a matchup problem between the generator and the identity column.

When I first encountered this problem, I was using the Microsoft driver until I found the FAQ in which it is stated that the MS driver is not supported in Hibernate. I then installed the JSQLConnect driver and still got the same error message

I am using sqlserver 2000 and it works fine in this situation.

hibernate-configuration:

<property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>

CustomerOrderHistory.xml:

<id
name="CustomerOrderHistoryId"
type="java.lang.Integer"
>
<column name="CustomerOrderHistoryId" length="10" not-null="true" unique="true" sql-type="int identity" />
<generator class="identity" />
</id>

I tried this in my hbm file and still got the same error. I do however notice you are using a different driver (jtds). I will try downloading this other driver and trying your solution again with that driver.


Thanks,
Paolo

A little update:

I got my Session object successfully inserted. I did it by doing the following:

1. setting my generator to "increment"
2. not setting my primary key to identity.
3. removing the association I had between Session and a linking table:



So I guess the next step for me is to reread the documentation and Hibernate books that I have access to on how to properly set up associations. As I have found, an incorrectly coded association can make life miserable.

Thanks for the help!