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@ejurka.com> wrote:

>
>
>On Tue, 5 Jun 2012, Dean Schulze wrote:
>
>>=20
>> 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:
>>=20
>
>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