JPA: how to map SQL Server uniqueidentifier type
The data type of the primary key property in the POJO determines the data type of its mapped DB column, which is specified by the Dialect class. According to the SQLServerDialect provided by hibernate, it does not have any data type that maps to uniqueidentifier
, and String
by default maps to varchar(255)
I think guid
strategy on a String
primary key only means that hibernate will generate a GUID value for POJO's primary key property and this generated GUID value will be inserted to the varchar(255)
column to simulate the effect of uniqueidentifier
You can try to override the mapping specified by the Dialect class by using the columnDefinition attribute of @Column
@Id
@GenericGenerator(name = "generator", strategy = "guid", parameters = {})
@GeneratedValue(generator = "generator")
@Column(name = "APPLICATION_ID" , columnDefinition="uniqueidentifier")
private String id;