Re: postgresql 7.4.6-6, hibernate-2.1.6, jdbc3 - Mailing list 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