Message-ID: <gh-pgjdbc-pgjdbc-2976-rc1395642948@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Thu, 16 Nov 2023 12:48:14 +0000
Subject: Re: [pgjdbc/pgjdbc] PR #2976: feat: fetch size for RefCursor
In-Reply-To: <gh-pgjdbc-pgjdbc-2976-rc1395614149@github.com>
References: <gh-pgjdbc-pgjdbc-2976@github.com> <gh-pgjdbc-pgjdbc-2976-rc1395614149@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 1395642948
X-GitHub-Comment-Type: review_comment
X-GitHub-Commit: 2be046b8c76fcda813f53d5d9070e13feb009dd6
X-GitHub-Issue: 2976
X-GitHub-Line: 185
X-GitHub-Path: pgjdbc/src/test/java/org/postgresql/test/jdbc2/RefCursorTest.java
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: review_comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/pull/2976#discussion_r1395642948
Content-Type: text/plain; charset=utf-8

(on pgjdbc/src/test/java/org/postgresql/test/jdbc2/RefCursorTest.java:185)

I'm not sure why not ?

Statement.setFetchSize() docs say 
```
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for ResultSet objects generated by this Statement. If the value specified is zero, then the hint is ignored. The default value is zero.
Params:
rows – the number of rows to fetch
Throws:
SQLException – if a database access error occurs, this method is called on a closed Statement or the condition rows >= 0 is not satisfied.
```

How else would they be used ?