| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Pavel Jbanov <pavel(dot)jbanov(at)shaw(dot)ca> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: postgresql 7.4.6-6, hibernate-2.1.6, jdbc3 |
| Date: | 2005-01-25 21:58:29 |
| Message-ID: | 41F6C105.6000304@opencloud.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Pavel Jbanov wrote:
> Sorry, gone unfinished. :/
>
> The exception is:
> Caused by: org.postgresql.util.PSQLException: ???????????? Byte f
> at
> org.postgresql.jdbc1.AbstractJdbc1ResultSet.getByte(AbstractJdbc1ResultSet.java:244)
I'd need to see the untranslated exception message to be sure, but..
getByte() expects a numeric value (TINYINT, although SMALLINT/int2 is
the closest mapping in PostgreSQL). You appear to be trying to retrieve
a text/varchar (or possibly boolean) value that can't be parsed as a
numeric value.
(there might be a driver bug here -- the JDBC datatype conversion tables
indicate you can use getByte() on BIT/BOOLEAN, but I'm not sure what the
exact conversion should be)
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Jbanov | 2005-01-25 21:58:40 | Re: postgresql 7.4.6-6, hibernate-2.1.6, jdbc3 |
| Previous Message | Pavel Jbanov | 2005-01-25 21:20:54 | Re: postgresql 7.4.6-6, hibernate-2.1.6, jdbc3 |