I have to import some tables to my new database via hibernate, and I need the same primary keys values for the tables.
Is there a way to set the IDENTITY_INSERT of the table to ON, so I can create an object with the same code, and save it with that code?

Thanks in advance!

ok, I have managed to do it by:


But when I assign the code of the hotel,
hotel.setCode(new Long(rs.getInt("code"))) and afterwards I save the hotel with hibernate:


I have an SqlException, which says:


How this can be? I already have setted the hotel's code...

can anyone help me please?

Seeing your mapping files would help. My guess is the mapping uses some id generator other than "assigned".

I'm having the same problem, but I'm using 3.1rc3. This is my mapping file:

<class name="com.sagebrushcorp.oberon.dataobject.Provider" table="PROVIDERS" lazy="false">
<id name="id">
<generator class="identity" />
</id>
<property name="name" />
<list name="contacts" table="CONTACTS" lazy="false" cascade="all-delete-orphan" fetch="join">
<key column="providerId" foreign-key="true" not-null="true" />
<list-index column="id" />
<composite-element class="com.sagebrushcorp.oberon.dataobject.Contact">
<property name="name"/>
<property name="email"/>
<property name="phone" />
<property name="type" />
</composite-element>
</list>
</class>


I've found that there's a MS bug on setting the IDENTITY_INSERT, so I patched my MSDE. All to no result... if I call the "set IDENTITY_INSERT PROVIDERS on" from SquirrelSQL, using the same jdbc driver, url, username and password as from hibernate, it works and the insert statements go through.

But if I call use session.connection().createStatement().executeUpdate("SET IDENTITY_INSERT PROVIDERS ON") from within the import program, it seems to have no effect and I still get:

ERROR| org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [com.sagebrushcorp.oberon.dataobject.Provider]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2077)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2426)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:908)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:344)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.sagebrushcorp.oberon.pcd.TestDataCreator.migrateProviders(TestDataCreator.java:92)
at com.sagebrushcorp.oberon.pcd.TestDataCreator.main(TestDataCreator.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: java.sql.SQLException: Cannot insert explicit value for identity column in table 'PROVIDERS' when IDENTITY_INSERT is set to OFF.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:620)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:483)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:445)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:402)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2061)
... 17 more

I guess it won't work with this mapping since you tell Hibernate to use the identity generator.
If you want to assign your value, you'll probably have to use the assigned generator.

I don't understand why "IDENTITY_INSERT" status was not set for the PROVIDERS table. I've set that by using the same connection the session is using, and still I get the SQLException (note that its not a HibernateException).