Message-ID: <gh-pgjdbc-pgjdbc-3722-c3139339661@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Thu, 31 Jul 2025 10:11:53 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3722: spring jdbc causes problems with uppercase db names since 42.7.5
In-Reply-To: <gh-pgjdbc-pgjdbc-3722@github.com>
References: <gh-pgjdbc-pgjdbc-3722@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 3139339661
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3722
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3722#issuecomment-3139339661
Content-Type: text/plain; charset=utf-8

Sorry for my late reply.

As to the change being in a minor release. It's somewhat fuzzy. We considered it a bug as we were just fixing it to adhere to the spec.

As to storesLowerCaseIdentifiers: This is what the javadoc says:
```

boolean | storesLowerCaseIdentifiers() | Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.

boolean | Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
boolean | Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
boolean | Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.

boolean	[storesLowerCaseIdentifiers](https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#storesLowerCaseIdentifiers--)()	
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.
boolean	[storesLowerCaseQuotedIdentifiers](https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#storesLowerCaseQuotedIdentifiers--)()	
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
boolean	[storesMixedCaseIdentifiers](https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#storesMixedCaseIdentifiers--)()	
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
boolean	[storesMixedCaseQuotedIdentifiers](https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#storesMixedCaseQuotedIdentifiers--)()	
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.


AFAICT, we are correct in saying  storesLowerCaseIdentifiers = true as that is what PostgreSQL does.

Seems the problem may be with spring