Fwd: PostgreSQL JDBC 42.7.5 returns an unexpected catalog name

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Vinhson(dot)Nguyen(at)ca(dot)ibm(dot)com, pgsql-jdbc(at)lists(dot)postgresql(dot)org
Cc: ca_data_access_external(at)wwpdl(dot)vnet(dot)ibm(dot)com
Subject: Fwd: PostgreSQL JDBC 42.7.5 returns an unexpected catalog name
Date: 2025-03-29 16:21:09
Message-ID: c35e2f5f2f1a9419d2bcef14cced3e12335972e3.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc

I think this belongs here.

-------- Forwarded Message --------
From: Vinhson Nguyen <Vinhson(dot)Nguyen(at)ca(dot)ibm(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Cc: ca_data_access_external(at)wwpdl(dot)vnet(dot)ibm(dot)com <ca_data_access_external(at)wwpdl(dot)vnet(dot)ibm(dot)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

Attachment Content-Type Size
ImportTest.java text/x-java 1.9 KB
PG_JDBC_42_7_4.PNG image/png 166.3 KB
PG_JDBC_42_7_5.PNG image/png 167.9 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Dunstan 2025-03-29 18:53:53 Re: PostgreSQL JDBC 42.7.5 returns an unexpected catalog name
Previous Message Tender Wang 2025-03-29 10:40:19 Re: BUG #18871: Cross-partition MERGE fails with unclear internal error

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andrew Dunstan 2025-03-29 18:53:53 Re: PostgreSQL JDBC 42.7.5 returns an unexpected catalog name
Previous Message Vinhson Nguyen 2025-03-28 18:24:22 PostgreSQL JDBC 42.7.5 returns an unexpected catalog name