PostgreSQL JDBC 42.7.5 returns an unexpected catalog name

I think this belongs here.

-------- Forwarded Message --------
From: Vinhson Nguyen <Vinhson.Nguyen@ca.ibm.com>
To: 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>

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.

Thank you in advance!
Vinhson Nguyen

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&gt;

cheers

andrew

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