Re: ResultSet & setFetchSize fails to stop heap failures
by books@[EMAIL PROTECTED]
(Kris Jurka)
May 28, 2008 at 03:34 PM
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/do***entation/83/query.html#query-with-cursor
Kris Jurka
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
