Hi,
Thanks. Actually the id was set as Identity column in the Tables also.
I removed the @GeneratedValue from both the entities.
But again I'm getting an error.
15:05:25,757 ERROR [JDBCExceptionReporter] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for identity column in table 'Address' when IDENTITY_INSERT is set to OFF.
15:05:25,757 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session

org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

   at org.hibernate.exception.SQLStateConverter.convert (SQLStateConverter.java:71)

   at org.hibernate.exception.JDBCExceptionHelper.convert (JDBCExceptionHelper.java:43)

   at org.hibernate.jdbc.AbstractBatcher.executeBatch (AbstractBatcher.java:249)

   at org.hibernate.jdbc.AbstractBatcher.prepareStatement (AbstractBatcher.java:92)

   at org.hibernate.jdbc.AbstractBatcher.prepareStatement (AbstractBatcher.java:87)

   at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement (AbstractBatcher.java:218)

   at org.hibernate.persister.entity.AbstractEntityPersister.insert (AbstractEntityPersister.java:2220)

   at org.hibernate.persister.entity.AbstractEntityPersister.insert (AbstractEntityPersister.java:2656)


In the Tables, I have id set as an Identity Column.

I looked for this on the Internet:
http://www.microsoft.com/downloads/details.aspx?FamilyId=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

It asks for SQL Server Service Pack 4.
I installed that but still getting the same error.
I'm new to EJB. Please help me out. :(



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4053429#4053429

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4053429
_______________________________________________
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user