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

Re: Bug with blobs?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Rob Kirkbride <rob(at)rkcomputing(dot)co(dot)uk>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bug with blobs?
Date: 2005-08-11 18:36:14
Message-ID: Pine.BSO.4.62.0508111334440.10158@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-08-11 18:38:15
Subject: Re: Memory leak in 8.0 JDBC driver?
Previous:From: Rob KirkbrideDate: 2005-08-11 18:09:48
Subject: Bug with blobs?

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