Message-ID: <gh-pgjdbc-pgjdbc-3424-c2918972010@github.com>
From: "mEkdal (@mEkdal)" <noreply+mEkdal@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Thu, 29 May 2025 10:26:17 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3424: Using postgresql-42.7.4.jar triggers PSQLException
In-Reply-To: <gh-pgjdbc-pgjdbc-3424@github.com>
References: <gh-pgjdbc-pgjdbc-3424@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: mEkdal
X-GitHub-Comment-Id: 2918972010
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3424
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3424#issuecomment-2918972010
Content-Type: text/plain; charset=utf-8

Testing 42.7.6.jar and the same error persists :) .

**This statement:**
_Statement stmt = conn.createStatement(ResultSet.CONCUR_READ_ONLY,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CLOSE_CURSORS_AT_COMMIT );_

**Trigger this error:**
_org.postgresql.util.PSQLException: Unknown value for ResultSet type
Unknown value for ResultSet type_

Thus not all types of resultset codes according to the manual is allowed since the problem appeared in 42.7.4.

BR
/Michael