Postgres Pro
Downloads
Home   >   mailing lists

Forcing use of cursor for large result sets - Mailing list pgsql-jdbc

From Brian G. Huber
Subject Forcing use of cursor for large result sets
Date
Msg-id 002e01c44b87$fd7bbe70$6400a8c0@bghthinkpad
Whole thread Raw
Responses Re: Forcing use of cursor for large result sets  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Tree view
Hello all -
 
I am attempting to force the use of a cursor for a resultset.  I have tried both forward-only and scrollable statements and am setting fetch size to 100 with a call to setFechSize(100) on the statement.  However, I do not think a cursor is being used because the entire result set is trying to cache, resulting in an outofMemoryError.  I am using pg74.213.jdbc3.jar with 7.4.2.
 
Any advice appreciated... Thanks-
BGH

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: urgent: autocommit & pg 7.4.1
Next
From: Cornelius Buschka
Date:
Subject: Postgresql 7.4, Latest JDBC Driver, SET AUTOCOMMIT not supported