OutOfMemoryError

From: rstepha1(at)nycap(dot)rr(dot)com
To: pgsql-jdbc(at)postgresql(dot)org
Subject: OutOfMemoryError
Date: 2005-08-29 14:09:19
Message-ID: 1803896180418d.180418d1803896@nyroc.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I am having a problem with performing large selects and getting a
java.lang.OutOfMemoryError.

Database: 8.0.1 JVM: 1.5 Driver: 8.0-311 JDBC 3

Using a simple select: SELECT col1, col2 FROM schm.tab1 WHERE col2
BETWEEN 30000 AND 31000

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?

Richard

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-08-29 16:12:46 Re: username and password for postgresql jdbc FTP site
Previous Message Clemens Eisserer 2005-08-29 11:28:23 Re: NullPointerException when calling ResultSet.absolute(int)