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

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

pgsql-jdbc by date

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

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