Re: ResultSet storing all rows with defaulftFetchSize to 5000

From: Mark Rotteveel <mark(at)lawinegevaar(dot)nl>
To: pgsql-jdbc(at)lists(dot)postgresql(dot)org
Subject: Re: ResultSet storing all rows with defaulftFetchSize to 5000
Date: 2018-02-14 13:37:20
Message-ID: 00642ca8-c07d-5839-2704-ef0031fea019@lawinegevaar.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 9-2-2018 23:09, Dave Cramer wrote:
> Jaime,
>
> 9.4.1208 is considerably out of date. You may want to upgrade.

The content of
https://jdbc.postgresql.org/documentation/documentation.html suggests
that the latest released documentation is for 9.4 (or at least, I always
read HEAD as meaning latest development content).

Maybe an idea to also add 42.x to that list?

Mark

> davec(at)postgresintl(dot)com <mailto:davec(at)postgresintl(dot)com>
> www.postgresintl.com <http://www.postgresintl.com>
>
> On 8 February 2018 at 19:13, Brad DeJong <bpd0018(at)gmail(dot)com
> <mailto:bpd0018(at)gmail(dot)com>> wrote:
>
>
>
> On Wed, Feb 7, 2018 at 1:00 PM, Jaime Soler <jaime(dot)soler(at)gmail(dot)com
> <mailto:jaime(dot)soler(at)gmail(dot)com>> wrote:
>
> ... ResultSet holdability is HOLD_CURSOR_OVER_COMMIT. ...
> And the postgresql comunity jdbc driver 9.4 documentation said:
> "... There are a number of restrictions which will make the
> driver silently fall back to fetch the whole ResultSet ..."

--
Mark Rotteveel

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2018-02-14 13:40:02 Re: ResultSet storing all rows with defaulftFetchSize to 5000
Previous Message Vladimir Sitnikov 2018-02-13 17:56:32 [pgjdbc/pgjdbc] 48b989: chore: remove unused variable lastKnownTime in Con...