CODEWITHSUNDEEP
javaspringdatabasejpah2
M06H
M06H

Reputation: 1783

Java UUID persisting in H2 and Sql Server with Spring JPA

Say I need persist some data in the database and one column is request_id which is a random uuid created by my application.

Firstly, What should be the type I use in my DDL create statements for H2 and SQL Server database? I am using H2 for local and sql server for production.

CREATE TABLE REQUESTS_DETAILS
(
    REQUEST_ID --what should be the type for H2 and SQLServer? 
    NAME NVARCHAR(20)   NOT NULL,
);

Secondly, What would be the corresponding java type when using Spring JPA Entity?

Upvotes: 0

Views: 6194

Answers (1)

Ajay Kumar
Ajay Kumar

Reputation: 3250

I have experienced going through all this for days recently. Take a look here and here.

Is this uuid going to be your Primary Key?

For the data type, it depends what is the business need for the data type of uuid. I would recommend you read this at least once.

To summarize and as per what I understood so far, use data type as String for your uuid and go for uuid4. If you are planning for Spring JPA/Hibernate, go for Long type for Primary/Foreign keys. That way you can easily maintain your keys and can index them easily rather than messing around indexing String type uuids.

And if you are looking for a unique identifier (as I was in my case) like uuid, go for a separate field in your entity of String type and generate uuid4 data type and treat it as a String. String is suggested as you can always port them from one DB to another without any hassle. Always consider the fact of migrating your data between different DBs (MSSQL/Oracle/DB2/Postgres etc).

Now, coming back to using UUID, you can always do:

@NotEmpty
@Column(name = "useruuid")
@GenericGenerator(name = "uuid", strategy = "uuid4")
private String useruuid;

and to generate UUIDs you can simply use :

UUID.randomUUID()

or

UUID.randomUUID().toString();

Take a look at here and here for sample project which I recently posted.

Upvotes: 1

Related Questions