JDBC Driver can't read UUID from database

From: Dean Schulze <dschulze(at)knowledgefactor(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: JDBC Driver can't read UUID from database
Date: 2012-06-05 23:26:53
Message-ID: CBF3F1DC.2E8%dschulze@knowledgefactor.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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:

Caused by: org.postgresql.util.PSQLException: Bad value for type long : dbada1e4-a165-4601-b34e-d08428cd81df

at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2796)

at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2019)

at org.postgresql.jdbc4.Jdbc4ResultSet.getBlob(Jdbc4ResultSet.java:52)

at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:335)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:104)

... 32 more

I've tried chaining the Hibernate annotations to treat them as Strings and CLOBs but I get the same exception.

Driver versions I've tried are 9.0-801.jdbc4 and 9.1-901.jdbc4

This is a show stopper.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-06-06 04:58:48 Re: BUG #6675: Box overlap with infinity edge
Previous Message Dave Page 2012-06-05 18:55:53 Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder