Re: OutOfMemoryError

From: Marc Herbert <Marc(dot)Herbert(at)emicnetworks(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: OutOfMemoryError
Date: 2005-08-29 19:03:36
Message-ID: 877je4o99z.fsf@meije.emic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

rstepha1(at)nycap(dot)rr(dot)com writes:

> It seems that the ResultSet is containing the entire selected set of
> data and not using a cursor within the database engine. I have tried
> setting the resultSetType and resultSetConcurrency to TYPE_FORWARD_ONLY
> and CONCUR_READ_ONLY respectively to hopefully force the cursor
> management to be server oriented, without success.
>
> It is possible to work around by increasing the heap size or lowering
> the selection criteria, but ...
>
> 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?

Try this:

myStatement.setFetchSize(43);

Warning: according to the JDBC spec, it's just a "hint", the driver
may still do what it thinks is good.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-08-29 19:03:39 Re: username and password for postgresql jdbc FTP site
Previous Message Kris Jurka 2005-08-29 19:00:43 Re: OutOfMemoryError