Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tybJi-008o96-KM for pgsql-bugs@arkaria.postgresql.org; Sat, 29 Mar 2025 18:54:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tybJh-00FDgp-4m for pgsql-bugs@arkaria.postgresql.org; Sat, 29 Mar 2025 18:54:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tybJg-00FDgh-My for pgsql-bugs@lists.postgresql.org; Sat, 29 Mar 2025 18:54:00 +0000 Received: from mail-qv1-xf35.google.com ([2607:f8b0:4864:20::f35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tybJe-001wC9-0h for pgsql-bugs@lists.postgresql.org; Sat, 29 Mar 2025 18:54:00 +0000 Received: by mail-qv1-xf35.google.com with SMTP id 6a1803df08f44-6df83fd01cbso15401826d6.2 for ; Sat, 29 Mar 2025 11:53:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1743274436; x=1743879236; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=+NC5uIP+Mp1cmTF9OpqLs6Oj+F9472xockYs/P1KUCw=; b=2q3S2cJTFp/wEVi4nMELaHEgwqvsbTahShaB5FAhOiF39YaodbHNaRNtflMPaAnSl9 Su16i7accIWbAPuNbBwjTfeN3abOsYq4SZs9nPX7Oa7qer47QEeczVAoAg+2Q/zPDU6g YiJ29+CPt9WnsW1otzsZApZhZA0XTZZsLR77gcwkxiDAC/hp1PNPY3InhPf31vj2n6Gb PML3t0zzkYBAnn4gsagY/zrZpf86LpijA1hqU+dRmQGerVkXPsj8qNBV5le7wRXrfnE/ c4MP+cNP1x+p6iyurzx64eCuzBwv+sS+r0Y7cONfBLAk9LLQRHxWL+mQHZBqMdC5O4YZ E3Ig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743274436; x=1743879236; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=+NC5uIP+Mp1cmTF9OpqLs6Oj+F9472xockYs/P1KUCw=; b=Kg62TBtZPs2tFf7mvq0ddmSjKx4zsZ/J0oH3JccAVEm89bPDw0yfYH/oBzSBUxqfX9 Tj5NNn20AWIYyP+N51gQZBNE7WgoZdYLYEqdTMXeGHnI/4rmoPLIVI6gBJhlL2Q9yVOg AwZe+p5oWsKLP/HHkvy97FahUz/TkKGV+yAqRHxOuaEaWKkRYAQl/EBkUUxIelPpKGNV jtD9q6PQvdolhzuo2kU4of84GMjAIl2Wu1uqFIdWuMA9iGl53wIviHQpXzISRIDJojk+ KK6Ns1Y9HhnXv+ebOfZ/zRXvS/iuJOE+/MwjquXuOue3ZMGpUOd9OJ/TD1XN2UkZBiOf ozcg== X-Forwarded-Encrypted: i=1; AJvYcCXIsDGycYN/mpvtwxUt24q55XaEULdtAWUMza++nNCUKL+bNjb1HRHoU6yoyriBRZYk5HRa+Qna1M2g@lists.postgresql.org X-Gm-Message-State: AOJu0YyU41bQLWcxPisHOUiNFc+MiQGgGOMT34/fpdM7L6q2V9YFaqRh MP4cf230jXbpFT82/HIaNlKJrBE6H8seq7LUcwHDOrJPj0SOCh/m7fwe9kezd1wyx1RljEp3ack d3B0= X-Gm-Gg: ASbGnct5ePDNCV7wk7A4sWVvtX8w30lCw8WUkUj9+vxnWIMlo4HqWpaBAr5k2KgTy6j zJqKvRcj/FwandhnrWfLwK3LJApB4/eSIdrVP89SQ6KDwG65HyrOdkS48o9vtHna6DXWpzX26Gg LDS6ziLwjcC1wRJnL9slRyAwgQxoMdAFOkuRl51gM5xg1wmMKdCdO8IGMIqS9O1nqjvMxiGShJg nWSZKim77ciW9IYao65fKc/Stb3VBEKQDL0E5Tg0PxvxlmPrnHHBsXR8YvQ9jmgqG4it9+OfWck oh+dWd5zbKdCsrF8367FpDjsKqW8m7oR1PjVG12rinI5d1GoR20kQRc= X-Google-Smtp-Source: AGHT+IHbofuoD/xUcUzUgGWiFzNI9/jHhXNYeb/SI+yBlRYxB1GRlNa3ioLl9vL8hfLB+rzDjKNdcA== X-Received: by 2002:a05:6214:405:b0:6e6:4969:f005 with SMTP id 6a1803df08f44-6eed61da11cmr56372156d6.30.1743274435967; Sat, 29 Mar 2025 11:53:55 -0700 (PDT) Received: from ?IPV6:2605:a601:a681:6b00::1cb? ([2605:a601:a681:6b00::1cb]) by smtp.googlemail.com with ESMTPSA id 6a1803df08f44-6eec97bde6asm25441556d6.125.2025.03.29.11.53.55 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 29 Mar 2025 11:53:55 -0700 (PDT) Message-ID: <2f8fb04d-9e15-4cef-922a-a10ba3c2c79e@dunslane.net> Date: Sat, 29 Mar 2025 14:53:53 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: PostgreSQL JDBC 42.7.5 returns an unexpected catalog name To: Vinhson Nguyen , "pgsql-bugs@lists.postgresql.org" Cc: "ca_data_access_external@wwpdl.vnet.ibm.com" References: From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAmwQTAQgARQIbAwIX gAIZAQULCQgHAgMiAgEGFQoJCAsCBBYCAwECHgcWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUC ZFlxxwUJGVGAbgAKCRCZ+n/LWfw7gXikB/9ZdcUy6CTBFIIuL/bVsc1eLEW/gJBjJBF6HxNY xgEkAgXAp4Lg4A5U+QB9GouFr7+GYxF0BU4hzoGhNPUWltxnHdMWP8nC/38LAqgMi8L/bbsm HW5YPBdWYaAZAPJQVfOAgjTbRUb26KSprpyrrJKW0ZmrZfjhNPcQ72jpWzoPLQqx2X6B0fru 1jq+cBh8lb6r1mJTim1T3JIn+F/v5VpdQS+EL8xqsHkfzKjIPsW3CIXpkypSk6saA55Rkkbl 26AW8ftPVB0Q6Lnn6FLt9CP0MGNixBQ55yq8r1K+nCBvCCjvQjM8RDm0UUum0WNl+ifQgTLO E8TWEnwVtkBf+3QWzsBNBE7KWFkBCADRnOM0FCzsYW6jtncg+dWIagjUZpvaClmqn/sJluLa Q3v1VXMQJzYs3eC1gh386W+XBwLRpDj3jzH81lX+p73Re3d3oJW7X+ffsxuzu5ZVdMUkqBYo nkAbKxr6gyJ12F/+JkUVzLcoTN+d/7YsQvUVi7NaKH8mJgjz112O4fUe3p9wfAaFa0RXHc5S GPzRTYRRlv/XZBIho4J2tkZOnteZJZ+GbxQVlINt6fd8P6al3MWOvpP/ExJPguEfjOsO6Njy xjo3WfpD4lHMOR/Oc3/8mScEF84rF2jXbsFgelWnbPWAvXY+pD0dXOFRkagGmC/viwBDqq5b 5tk76kKmUbZxABEBAAHCwHwEGAEIACYCGwwWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUCZFlx 5wUJGVGAjgAKCRCZ+n/LWfw7gf+iB/4g8CPY5jihf5r/8EsoIGe2H+dpVmpPF8YGBzTIvCz/ fQoOq8AX/pE76QEuFnFZWfjw+wgBXgCVmkox2Eflkk6z4ND3pcwGZ6CfCxTQCDk/dij+2DQ4 6bmDCy/sBgcbz9mTpoLC11HLoPae6YN9nBNQRZDcEFEu54OaVOqlIdbA6m+POIBCXZdHOFc0 WoDTgxHRzC1jgQNidyd6tKqcsVJs0dzF0oKTmFFmUAqTdJO12LBuNA1rlqrR3EtpYk8B/wtS 5dIMD7Q8hwQpL+4C6GNpb6ZKnPkLi47pDOLhz2qBrqN+rqUEsT3YnExYpzj5yOBi+FlmV1Hw 49QYe1sn2ZPs In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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: cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com