Re: Bug with blobs?

From: Rob Kirkbride <rob(at)rkcomputing(dot)co(dot)uk>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bug with blobs?
Date: 2005-08-11 19:55:51
Message-ID: 42FBAD47.5010403@rkcomputing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Kris Jurka wrote:

>
>
> On Thu, 11 Aug 2005, Rob Kirkbride wrote:
>
>> I was getting an exception thrown when using Hibernate to read blobs but
>> I've pared it down to something very simple - hopefully it's just
>> something silly.
>>
>> String query = "select imageblob from tempimages where id=1";
>>
>> java.sql.Blob blob = rs.getBlob("imageblob");
>>
>> It throws a
>> org.postgresql.util.PSQLException: Bad value for type int :
>> \377\330\377\340\000 .... <blob data removed>
>> at
>> org.postgresql.jdbc2.AbstractJdbc2ResultSet.toInt(AbstractJdbc2ResultSet.java:2528)
>>
>> at
>
>
> Postgresql maps Blob data to the oid datatype, not bytea. For bytea
> data you should use getBytes() not getBlob.
>
> Kris Jurka
>
Thanks. It's actually being done within Hibernate so I don't have a
great deal of control but I'll try using the binary type which works
with bytea and hopefully will be ok.

Rob

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2005-08-11 19:56:37 Re: Memory leak in 8.0 JDBC driver?
Previous Message Kris Jurka 2005-08-11 18:38:15 Re: Memory leak in 8.0 JDBC driver?