CODEWITHSUNDEEP
defaulth2uuid
Basil Bourque
Basil Bourque

Reputation: 338614

Generate UUID values by default for each row on column of UUID type in H2 Database Engine

In the H2 database, on a table with a column of UUID data type, how do we specify that we want H2 to generate a UUID value by default when an INSERT omits that field?

I know how to generate a UUID. I have read the Question, How to insert a specific UUID in h2 database?.

My question is about how to ask H2 to generate the UUID value on my behalf.

Upvotes: 20

Views: 44995

Answers (2)

Thomas Mueller
Thomas Mueller

Reputation: 50097

In SQL

You can use built-in function RANDOM_UUID():

create table test(id int primary key, data uuid default random_uuid());
insert into test(id) values(1);
select * from test;

Note that using the UUID type (or any other randomly generated data that doesn't have any natural ordering) as the primary key will result in performance problems if there are more than a few million rows (with relational databases in general, not just with H2).

Upvotes: 37

JeSa
JeSa

Reputation: 607

In JPA/Hibernate

After googling for hours I've created a simple solution for JPA or Hibernate, according to @Thomas Mueller.

@Id
@GeneratedValue(generator = "UUID")
@GenericGenerator(
        name = "UUID",
        strategy = "org.hibernate.id.UUIDGenerator"
)
@Column(name = "ID", updatable = false, nullable = false)
@ColumnDefault("random_uuid()")
@Type(type = "uuid-char")
@Getter
@Setter
private UUID id;

So @Type(type = "uuid-char") makes your field a VARCHAR(255) if you need it (it's binary by default)

And @ColumnDefault("random_uuid()") puts the default value for generated table DDL

Upvotes: 26

Related Questions