Message-ID: <gh-pgjdbc-pgjdbc-3424@github.com>
From: "mEkdal (@mEkdal)" <noreply+mEkdal@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Fri, 25 Oct 2024 13:33:57 +0000
Subject: [pgjdbc/pgjdbc] issue #3424: Using postgresql-42.7.4.jar triggers PSQLException
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Assignees: davecramer
X-GitHub-Author-Id: 26957803
X-GitHub-Author-Login: mEkdal
X-GitHub-Issue: 3424
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-State: open
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3424
Content-Type: text/plain; charset=utf-8

When using postgresql-42.7.4.jar the "org.postgresql.util.PSQLException: Unknown value for ResultSet type
Unknown value for ResultSet type" is triggered.

Java version: openjdk version "1.8.0_422"
OS Version: Microsoft Windows 11 Home. 10.0.22631 Build 22631
PostgreSQL Version:  "PostgreSQL 13.12, compiled by Visual C++ build 1914, 64-bit"

Is works in a number of earlier versions up to postgresql-42.7.3.jar

The statement looks like this:
Statement stmt = conn.createStatement(ResultSet.CONCUR_READ_ONLY,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CLOSE_CURSORS_AT_COMMIT ); 

The values are the same in both 42.7.3 and 42.7.4 but fails in 42.7.4.
System.out.println(ResultSet.CONCUR_READ_ONLY+" "+ResultSet.TYPE_FORWARD_ONLY+" "+ResultSet.CLOSE_CURSORS_AT_COMMIT);
Result: 1007 1003 2