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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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