Message-ID: <gh-pgjdbc-pgjdbc-2861-c2225245748@github.com>
From: "SuperPat45 (@SuperPat45)" <noreply+SuperPat45@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Fri, 12 Jul 2024 10:04:07 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #2861: setFetchSize is ignored?
In-Reply-To: <gh-pgjdbc-pgjdbc-2861@github.com>
References: <gh-pgjdbc-pgjdbc-2861@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: SuperPat45
X-GitHub-Comment-Id: 2225245748
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2024-07-14T11:55:00Z
X-GitHub-Issue: 2861
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/2861#issuecomment-2225245748
Content-Type: text/plain; charset=utf-8

A solution would be to take account of the fetchSize despite the autocommit mode, but as soon as the first commit occurs, load all the remaining data into all the opened ResultSets to avoid errors.