Re: Blobs and "No results were returned by the query."

From: "David Wall" <d(dot)wall(at)computer(dot)org>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Blobs and "No results were returned by the query."
Date: 2002-09-10 16:05:08
Message-ID: 006f01c258e3$d60b9920$3201a8c0@expertrade.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2002-09-10 16:36:28 Re: [JDBC] problem with new autocommit config parameter
Previous Message Stephan Szabo 2002-09-10 15:58:14 Re: [JDBC] Selecting Varchar range (through JDBC).