Message-ID: <gh-pgjdbc-pgjdbc-3426-c2639783473@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Thu, 06 Feb 2025 13:08:18 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3426: 42.7.4 introduced error when binding java.io.FileInputStream
In-Reply-To: <gh-pgjdbc-pgjdbc-3426@github.com>
References: <gh-pgjdbc-pgjdbc-3426@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 2639783473
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2025-02-06T13:32:37Z
X-GitHub-Issue: 3426
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3426#issuecomment-2639783473
Content-Type: text/plain; charset=utf-8

Looks like 

'''
    // validation check for allowed values of resultset type
    if (rsType != ResultSet.TYPE_FORWARD_ONLY && rsType != ResultSet.TYPE_SCROLL_INSENSITIVE && rsType != ResultSet.TYPE_SCROLL_SENSITIVE) {
      throw new PSQLException(GT.tr("Unknown value for ResultSet type"),
          PSQLState.INVALID_PARAMETER_VALUE);
    }
'''
introduced in 
https://github.com/pgjdbc/pgjdbc/commit/e0a614b79fc39a01fc0b7911955f5bcb47d0179b 
is throwing the exception.

However looking at your code it seems that you have an error which this picks up. If
```
Statement stmt = con.createStatement(ResultSet.CONCUR_READ_ONLY,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CLOSE_CURSORS_AT_COMMIT );
``` 
is what you have the concurrency and resultset type are in the wrong positions. It should be

```
Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.CLOSE_CURSORS_AT_COMMIT );
```

Let me know .