Re: Blobs and "No results were returned by the query." - Mailing list pgsql-jdbc

From David Wall
Subject Re: Blobs and "No results were returned by the query."
Date
Msg-id 006f01c258e3$d60b9920$3201a8c0@expertrade.com
Whole thread Raw
In response to Blobs and "No results were returned by the query."  (Michael Andreasen <michael@dunlops.com>)
List pgsql-jdbc
It's unfortunate, but the new blob code is pretty buggy.  I think the dev
builds are better, but I can't say for sure since they are not exactly
current (so you'd have to extract from CVS and do your own builds).

I'm not sure, but is it possible your Blob was NULL in that case?  I got a
similar fastpath error when doing a rs.getBlob() and the OID was 0 (NULL),
but while I'm comfortable looking at the JDBC part of the code, I'm unable
to easily tweak the fastpath parts to properly detect NULL.  Of course, in
your sample code, you're not doing an rs.wasNull() to check that you
actually got a blob.

David


pgsql-jdbc by date:

Previous
From: Daryl Beattie
Date:
Subject: Re: [GENERAL] Selecting Varchar range (through JDBC).
Next
From: Barry Lind
Date:
Subject: Re: [HACKERS] problem with new autocommit config parameter