Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group