On Wed, 28 May 2008, U. George wrote:
> The resultset is a very large set of rows ( each row 2 ints and a
> bunch of doubles ) . I am unable to convince jdbc to fetch one row at
> a time, and avoid the heap failure.
> Is there a way, or just a bug, or feature deficiency?
To do partial fetches you must turn autocommit off. See:
http://jdbc.postgresql.org/documentation/83/query.html#query-with-cursor
Kris Jurka