Skip site navigation (1) Skip section navigation (2)

Re: JDBC Driver can't read UUID from database

From: Dean Schulze <dschulze(at)knowledgefactor(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: JDBC Driver can't read UUID from database
Date: 2012-06-11 02:43:47
Message-ID: 285378F79EC333408F3AAE73259CCD40626D6C@mbx024-w1-ca-5.exch024.domain.local (view raw or flat)
Thread:
Lists: pgsql-bugs
Thanks.

Out of curiosity why didn't the driver map the Postgresql UUID to a Java
UUID?


On 6/6/12 2:12 AM, "Kris Jurka" <books(at)ejurka(dot)com> wrote:

>
>
>On Tue, 5 Jun 2012, Dean Schulze wrote:
>
>> 
>> I'm using Hibernate (3.6 and 4.0) with Postgresql 9.1.  Our tables have
>> UUIDs in them and your driver is trying to convert UUIDs to longs:
>> 
>
>This is a hibernate mapping problem, not a JDBC Driver problem.  If you
>have a plain ResultSet and call getString() on a UUID field, it will
>certainly work.  Mapping the UUID to BLOB or CLOB is incorrect.  I'm not
>sure why your attempt to map it to a String didn't work, but you are
>not convincing Hibernate to use a plain getString call.
>
>Kris Jurka


In response to

Responses

pgsql-bugs by date

Next:From: Edmund HornerDate: 2012-06-11 05:30:16
Subject: Re: 9.2 beta1 libxml2 can't be loaded on Windows
Previous:From: Craig RingerDate: 2012-06-11 02:28:01
Subject: Re: An I/O error occured while sending to the backend

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group