Hibernate Community • View topic - PostgreSQL 8.3 uuid type and JPA columnDefinition=uuid

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

PostgreSQL 8.3 uuid type and JPA columnDefinition=uuid

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

erace

Post subject: PostgreSQL 8.3 uuid type and JPA columnDefinition=uuid

Posted: Wed Mar 05, 2008 6:09 pm

Newbie

Joined: Tue Feb 22, 2005 10:35 am
Posts: 2

Hi,

I am trying to map my entity so the id is an uuid. I would like to use uuid type that is available in PostgreSQL 8.3.

I am doing something like this

Code:

@Id @Column(columnDefinition="uuid", nullable=false)
private String id;

(yes I know it will not be portable)

Table is created correctly (i.e. column is of type uuid) but when I try to persist anything I get the following exception:

Quote:

ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: column "id" is of type uuid but expression is of type character varying

.
When I call insert statement with uuid that has been generated everything works.

Anyone might have an idea how to solve this?

Rgds,

/p

Top

erace

Post subject: No response

Posted: Sun Mar 09, 2008 2:10 pm