| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2005-08-11 18:38:15 | Re: Memory leak in 8.0 JDBC driver? |
| Previous Message | Rob Kirkbride | 2005-08-11 18:09:48 | Bug with blobs? |