Sunday, May 1, 2011

Postgres + Hibernate + Java UUID

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?

From stackoverflow
  • 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.

  • you could try with:

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

    where columnDefinition is a fragment of native SQL

  • 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.

  • 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.

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.