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