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.
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 |