Skip site navigation (1) Skip section navigation (2)

Re: postgresql 7.4.6-6, hibernate-2.1.6, jdbc3

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 (view raw or flat)
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

In response to

Responses

pgsql-jdbc by date

Next:From: Pavel JbanovDate: 2005-01-25 21:58:40
Subject: Re: postgresql 7.4.6-6, hibernate-2.1.6, jdbc3
Previous:From: Pavel JbanovDate: 2005-01-25 21:20:54
Subject: Re: postgresql 7.4.6-6, hibernate-2.1.6, jdbc3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group