Postgres + Hibernate + Java UUID

Question

2

I want to use PostgreSQL's native UUID type with a Java UUID. I am using Hibernate as my JPA provider and ORM. If I try to save it directly, it is just saved as a bytea in Postgres.

How can I do this?

edited Apr 20 '09 at 13:51

asked Apr 17 '09 at 14:36

Grasper
136●4●26

94% accept rate

Stephen Denne · Answer 1 · 2009-07-26 22:00:21Z

Try use the latest development version of the JDBC driver (Currently 8.4dev-700), or wait for the next release version. (Edited to add: 8.4-701 has been released)

The release notes mention this change:

Map the database uuid type to java.util.UUID. This only works for relatively new server (8.3) and JDK (1.5) versions.

araqnid · Answer 2 · 2009-04-17 17:39:51Z

0

In non-JPA usage I'd create a UserType to format the UUID as a string that PostgreSQL accepts, then just give the name of the UserType implementation as the column type.

answered Apr 17 '09 at 17:39

araqnid
3,819●2●8

dfa · Answer 3 · 2009-04-21 14:31:03Z

0

you could try with:

 @Column(name="foo", columnDefinition="uuid")

where columnDefinition is a fragment of native SQL

answered Apr 21 '09 at 14:31

dfa
20k●3●16●55

StaxMan · Answer 4 · 2009-04-22 21:50:18Z

0

Perhaps you can get UUID type to be auto-converted to a String (uuid.toString() should give the canonical 36-char representation)? DBs usually convert things reliably between Strings and native types.

answered Apr 22 '09 at 21:50

StaxMan
1,702●4●13

Postgres + Hibernate + Java UUID

4 Answers

Your Answer

Not the answer you're looking for? Browse other questions tagged java postgresql hibernate uuid j2ee or ask your own question.

Hello World!

Related