Re: JDBC Driver can't read UUID from database

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