Message-ID: <gh-pgjdbc-pgjdbc-3731-c3139317561@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Thu, 31 Jul 2025 10:05:45 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3731: Entity Manager Creation issue with jdbc driver > 42.7.4
In-Reply-To: <gh-pgjdbc-pgjdbc-3731@github.com>
References: <gh-pgjdbc-pgjdbc-3731@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 3139317561
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3731
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3731#issuecomment-3139317561
Content-Type: text/plain; charset=utf-8

@monclaf OK, as I suspected in 42.7.5 we changed the code to make sure the catalog was the same as the current database. This is consistent with the JDBC spec. 
It looks like if you want to use an upper case database name you need to use delimiters around it. 
See https://github.com/apache/openjpa/blob/87e253b9e58a8f061b0431a1ab4df3e5e1660519/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/identifier/DBIdentifierUtilImpl.java#L407-L431

If there are no delimiters it folds the name to lowercase