File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "SQL server: identity persistence exception" Watch "SQL server: identity persistence exception" New topic

SQL server: identity persistence exception

H Paul
Ranch Hand

Joined: Jul 26, 2011
Posts: 471
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: Cannot insert explicit value for identity column in table 'CUSTOMER' when IDENTITY_INSERT is set to OFF.

So at database level, I set


When JPA persist again, I still got the same exception. What do I miss?
Consider Paul's rocket mass heater.
subject: SQL server: identity persistence exception
It's not a secret anymore!