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

Re: ResultSet & setFetchSize fails to stop heap failures

From: Kris Jurka <books(at)ejurka(dot)com>
To: "U(dot) George" <netbeans(at)gatworks(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ResultSet & setFetchSize fails to stop heap failures
Date: 2008-05-28 20:28:51
Message-ID: Pine.BSO.4.64.0805281622000.13145@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Wed, 28 May 2008, U. George wrote:

>> To do partial fetches you must turn autocommit off.  See:
>> 
>
> Yup, that did it.  I suppose there is a reason why no exception is 
> thrown at the execute, or an error for the setFetchSize when autocommit 
> is still on?
>

You can't throw an exception at setFetchSize because you could do 
setFetchSize(N) and then setAutoCommit(false).  Throwing an exception at 
execute time is possible, but I don't think the driver should.  Fetch size 
is just a hint, so it's not a failure if it isn't used.

Kris Jurka

In response to

pgsql-jdbc by date

Next:From: Jignesh K. ShahDate: 2008-05-29 03:13:12
Subject: Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
Previous:From: U. GeorgeDate: 2008-05-28 20:15:32
Subject: Re: ResultSet & setFetchSize fails to stop heap failures

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