Re: Bug with blobs?

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