Re: HELP: How to tame the 8.3.x JDBC driver with a biq query result set - Mailing list pgsql-jdbc

On Thu, 15 Apr 2010, Dave Crooke wrote:

> I have a huge table I need to do a full table scan on.
>
> 2. When I use setFetchSize(), which is both a JDBC standard and the
> recommendation on the page below ...
>
> http://jdbc.postgresql.org/documentation/83/query.html#query-with-cursor
>
> ... it bails after about 900ms / 100 fetches / a few thousand rows, with the
> following PG internal error:
>
> org.postgresql.util.PSQLException: ERROR: portal "C_14" does not exist
>

I'm guessing that you have committed the transaction so the portal
(backing the query) gets cleaned up.  To keep a portal open across
transactions you need the WITH HOLD option to DECLARE CURSOR.  There is no
way to do that at the protocol level to work with the current query setup
you have.  If that's what you need, you'll need to rewrite it to DECLARE
CURSOR and then issue the FETCHes yourself.

Kris Jurka