Message-ID: <gh-pgjdbc-pgjdbc-3424-c2470553098@github.com>
From: "mEkdal (@mEkdal)" <noreply+mEkdal@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Tue, 12 Nov 2024 13:37:57 +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: 2470553098
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-2470553098
Content-Type: text/plain; charset=utf-8

package Jvakt;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class test07 {

    public static void main(String[] args) throws Exception {

        try (Connection con = DriverManager.getConnection(
                "jdbc:postgresql://localhost/Jvakt", "test", "test")) {
            Statement stmt = con.createStatement(ResultSet.CONCUR_READ_ONLY,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CLOSE_CURSORS_AT_COMMIT );
            
            	stmt.executeQuery("create table streamtable (bin text, str text)");
           	
            }
        }
    }


42.7.4.jar   =>
Exception in thread "main" org.postgresql.util.PSQLException: Unknown value for ResultSet type
	at org.postgresql.jdbc.PgStatement.<init>(PgStatement.java:166)
	at org.postgresql.jdbc.PgConnection.createStatement(PgConnection.java:1404)
	at Jvakt.test07.main(test07.java:16)

42.7.3.jar  =>
The table streamtable is created. I ignored the exeption below. 
Exception in thread "main" org.postgresql.util.PSQLException: No results were returned by the query.
	at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:252)
	at Jvakt.test07.main(test07.java:18)