Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: ResultSet & setFetchSize fails to stop heap failures
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: "U. George" <netbeans(at)gatworks(dot)com>
- Cc: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: ResultSet & setFetchSize fails to stop heap failures
- Date: Wed, 28 May 2008 15:34:34 -0400 (EDT)
- Message-id: <Pine(dot)BSO(dot)4(dot)64(dot)0805281533140(dot)23353(at)leary(dot)csoft(dot)net>
On Wed, 28 May 2008, U. George wrote:
The resultset is a very large set of rows ( each row 2 ints and a bunch of doubles ) . I am unable to convince jdbc to fetch one row at a time, and avoid the heap failure. Is there a way, or just a bug, or feature deficiency?
To do partial fetches you must turn autocommit off. See: http://jdbc.postgresql.org/documentation/83/query.html#query-with-cursor Kris Jurka
- Follow-Ups:
- Re: ResultSet & setFetchSize fails to stop heap failures
- From: U. George
- Re: ResultSet & setFetchSize fails to stop heap failures
- References:
- ResultSet & setFetchSize fails to stop heap failures
- From: U. George
- ResultSet & setFetchSize fails to stop heap failures
- Prev by Date: ResultSet & setFetchSize fails to stop heap failures
- Next by Date: Re: ResultSet & setFetchSize fails to stop heap failures
- Previous by thread: ResultSet & setFetchSize fails to stop heap failures
- Next by thread: Re: ResultSet & setFetchSize fails to stop heap failures
- Indexes: