I've a non id (key) column, a regular column that I want to defined with identity.
1. For HSQL
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
When JPA persist again, I still got the same exception. What do I miss?
1. For HSQL
is OK@Column(name = "NUMBER", columnDefinition="INTEGER GENERATED BY DEFAULT AS IDENTITY (start with 1)")
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?