File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes SQL server: identity persistence exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "SQL server: identity persistence exception" Watch "SQL server: identity persistence exception" New topic
Author

SQL server: identity persistence exception

H Paul
Ranch Hand

Joined: Jul 26, 2011
Posts: 471
    
    4
I've a non id (key) column, a regular column that I want to defined with identity.

1. For HSQL
@Column(name = "NUMBER", columnDefinition="INTEGER GENERATED BY DEFAULT AS IDENTITY (start with 1)")
is OK

2. When I switch to Microsoft SQL server


When JPA persist, I got below exception.

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for identity column in table 'CUSTOMER' when IDENTITY_INSERT is set to OFF.

So at database level, I set

SET IDENTITY_INSERT CUSTOMER ON

When JPA persist again, I still got the same exception. What do I miss?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL server: identity persistence exception