Re: OutOfMemoryError

From: Kris Jurka <books(at)ejurka(dot)com>
To: rstepha1(at)nycap(dot)rr(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: OutOfMemoryError
Date: 2005-08-29 19:00:43
Message-ID: Pine.BSO.4.62.0508291400060.3816@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, 29 Aug 2005 rstepha1(at)nycap(dot)rr(dot)com wrote:

> I am having a problem with performing large selects and getting a
> java.lang.OutOfMemoryError.
>
> How do you get the driver to not retrieve all of the data into the
> ResultSet? Is there a setting either within the JDBC driver, or at the
> database that would determine caching X number of rows returned at a time?
>

http://jdbc.postgresql.org/documentation/80/query.html#query-with-cursor

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Marc Herbert 2005-08-29 19:03:36 Re: OutOfMemoryError
Previous Message Peter Wilkins 2005-08-29 18:21:11 Re: username and password for postgresql jdbc FTP site