Re: PostgreSQL JDBC 42.7.5 returns an unexpected catalog name

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: Vinhson Nguyen <Vinhson.Nguyen@ca.ibm.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Cc: "ca_data_access_external@wwpdl.vnet.ibm.com" <ca_data_access_external@wwpdl.vnet.ibm.com>
Date: 2025-03-29T18:53:53Z
Lists: pgsql-bugs
On 2025-03-28 Fr 2:24 PM, Vinhson Nguyen wrote:
> 1) Problem Description:
> When upgrading our application to a new PostgreSQL JDBC driver 42.7.5 (from 42.7.4), we got an expected catalog name in the result set returned by DatabaseMetadata.getSchemas().
>
> Expected catalog name:  null (42.7.4)
> Unexpected catalog name:  dbcert (42.7.5)
>
> 2) Connection Info:
> URL used:
> jdbc:postgresql://cteds721.fyre.ibm.com:54172/dbcert
>
> Driver name/Version:
> org.postgresql.Driver/postgresql-42.7.5.jar
>
> userID/pw: dbcert1/***********
>
> 3) Attachements:
> a) PG_JDBC_42_7_4.PNG:  Screenshot showing an expected catalog name (null) with driver version 42.7.4.
> b) PG_JDBC_42_7_5.PNG:  Screenshot showing an unexpected catalog name (dbcert) with driver version 42.7.5.
> c) ImportTest.java:  Java test program used in (a) and (b).
>
> If you need any additional details, please let me know.


You should probably raise this here: 
<https://github.com/pgjdbc/pgjdbc/issues>


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com