Persisting UUID in PostgreSQL using JPA

by

The PostgreSQL JDBC driver has chosen an unfortunately way to represent non-JDBC-standard type codes. They simply map all of them to Types.OTHER. Long story short, you need to enable a special Hibernate type mapping for handling UUID mappings (to columns of the postgres-specific uuid datatype):

@Id
@Column(name = "customer_id")
@org.hibernate.annotations.Type(type="org.hibernate.type.PostgresUUIDType")
private UUID id;

or more succinctly:

@Id
@Column(name = "customer_id")
@org.hibernate.annotations.Type(type="pg-uuid")
private UUID id;

Another (better) option is to register org.hibernate.type.PostgresUUIDType as the default Hibernate type mapping for all attributes exposed as java.util.UUID. That is covered in the documentation @ http://docs.jboss.org/hibernate/orm/4.1/manual/en-US/html/ch06.html#types-registry

More Related Contents:

  1. Mapping PostgreSQL JSON column to a Hibernate entity property
  2. what is @JoinColumn and how it is used in Hibernate
  3. @BatchSize a smart or stupid use?
  4. Large Objects may not be used in auto-commit mode
  5. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  6. Hibernate Annotations – Which is better, field or property access?
  7. How to map calculated properties with JPA and Hibernate
  8. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  9. When to use EntityManager.find() vs EntityManager.getReference() with JPA
  10. How to generate the JPA entity Metamodel?
  11. Hibernate: Automatically creating/updating the db tables based on entity classes
  12. How to use @Id with String Type in JPA / Hibernate?
  13. JPA Hibernate One-to-One relationship
  14. I found JPA, or alike, don’t encourage DAO pattern
  15. Hibernate SessionFactory vs. JPA EntityManagerFactory
  16. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  17. Deploying application using Hibernate JPA 2.1 to IBM WebSphere gives NullPointerException
  18. Hibernate use of PostgreSQL sequence does not affect sequence table
  19. JPA Multiple Embedded fields
  20. JPA (Hibernate) and custom table prefixes
  21. Create the perfect JPA entity [closed]
  22. Delete Not Working with JpaRepository
  23. IllegalStateException with Hibernate 4 and ManyToOne cascading
  24. Force refresh of collection JPA entityManager
  25. Hibernate triggering constraint violations using orphanRemoval
  26. Error creating bean with name ‘entityManagerFactory
  27. JPA: How do I specify the table name corresponding to a class at runtime?
  28. How to force Hibernate to return dates as java.util.Date instead of Timestamp?
  29. How to make a database listener with java?
  30. How to use Postgres JSONB datatype with JPA?

Leave a Comment