Hi Maxim,
I saw that openjpa v4.1.1 was not verified with PostgreSQL v17 and PostgreSQL
JDBC Driver v42.7.5 :
(PostgreSQL 8.3.5, 8.4, 9, 11, 12, 13 / PostgreSQL Native Driver
8.3 JDBC3 (build 603), 8.4 JDBC3 (build 701), 42.2.5, , 42.2.19)
So do you think that it can explain why this property does not work in my case ?
Thanks
Fred
-----Message d'origine-----
De : MONCLAR Frederic
Envoyé : jeudi 14 août 2025 09:35
À : 'Maxim Solodovnik' <solomax...@gmail.com>
Cc : dev@openjpa.apache.org
Objet : RE: how to get database name case preserved in url of ConnectionURL
property
Critère de diffusion : Confidentiel
Hi Maxim,
Thank you for your reply.
I attach the picture to my reply in order to make it visible. This image is a
capture of the code changes in PostgreSQL JDBC Driver v42.7.5 that create my
issue. It is annoying that the JDBC driver has evolved like that on a minor
version.
I tried what you proposed : <property name="openjpa.jdbc.DBDictionary"
value="postgres(schemaCase=preserve)"/> but it does not work. I still get the
error where the lib try to create tables like if the table does not exists :-(
Fred
14-08-2025 09:32:10.317 [main] INFO [d.t.e.APersistencedb][openPhaseRemote]
{openjpa.ConnectionURL=jdbc:postgresql://localhost:9999/DB_TEST,
openjpa.ConnectionUserName=postgres, openjpa.ConnectionPassword=postgres}
14-08-2025 09:32:12.031 [main] ERROR [d.t.e.APersistencedb][openPhaseRemote]
ERREUR: la relation « openjpa_sequence_table » existe déjà {stmnt 971404566
CREATE TABLE OPENJPA_SEQUENCE_TABLE (ID SMALLINT NOT NULL, SEQUENCE_VALUE
BIGINT, PRIMARY KEY (ID))} [code=0, state=42P07]
org.apache.openjpa.persistence.PersistenceException: ERREUR: la relation «
openjpa_sequence_table » existe déjà {stmnt 971404566 CREATE TABLE
OPENJPA_SEQUENCE_TABLE (ID SMALLINT NOT NULL, SEQUENCE_VALUE BIGINT, PRIMARY
KEY (ID))} [code=0, state=42P07]
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:625)
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:488)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:173)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:178)
-----Message d'origine-----
De : Maxim Solodovnik <solomax...@gmail.com> Envoyé : jeudi 14 août 2025 06:46
À : MONCLAR Frederic <frederic.monc...@thalesaleniaspace.com>
Cc : dev@openjpa.apache.org
Objet : Re: how to get database name case preserved in url of ConnectionURL
property
re-sending with modified email of TS :)
On Thu, 14 Aug 2025 at 11:44, Maxim Solodovnik <solomax...@gmail.com> wrote:
>
> Hello Fred,
>
> welcome to the list :)
>
>
> On Wed, 13 Aug 2025 at 13:35, MONCLAR Frederic
> <frederic.monc...@thalesaleniaspace.com.invalid> wrote:
> >
> > Hello,
> >
> >
> >
> > I would like to know if there is an option in persistence.xml or in
> > creating entity manager factory methods where I can specify to use
> > “CASE_PRESERVE” in order to preserve the case of the name of the database
> > in ConnectionURL property?
> >
>
> It seems to me this question better fits users@openjpa.a.o
> mailing-list :))
>
> >
> >
> > I recently posted an issue on PostgreSQL JDBC Driver v42.7.5/6/7 :
> > https://github.com/pgjdbc/pgjdbc/issues/3731 because I get the following
> > exception :
> >
> >
>
> I would try to set
>
> openjpa.jdbc.DBDictionary: postgres(schemaCase=preserve)
>
> like this:
>
> <properties>
> <property name="openjpa.jdbc.DBDictionary"
> value="postgres(schemaCase=preserve)" /> </properties>
>
>
> >
> > 22-07-2025 13:05:52.082 [pool-6-thread-1] ERROR
> > [c.t.s.s.p.d.i.f.APersistencedb][openPhaseRemote] ERREUR: la
> > relation « element » existe déjà {stmnt 445531560 CREATE TABLE
> > element ...))} [code=0, state=42P07]
> > org.apache.openjpa.persistence.PersistenceException: ERREUR: la
> > relation « element » existe déjà {stmnt 445531560 CREATE TABLE
> > element ...)} [code=0, state=42P07] at
> > org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:625
> > ) at
> > org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:488
> > )
> >
> >
> >
> > when I try to create an EntityManager and it was working fine until version
> > 42.7.4 :
> >
> >
> >
> > String dbUrl = "jdbc:postgresql://" +
> > "localhost:9999/\"DB_TEST\"";
> >
> > properties.put("openjpa.ConnectionURL", dbUrl);
> >
> > properties.put("openjpa.ConnectionUserName", "postgres");
> >
> > properties.put("openjpa.ConnectionPassword", "postgres");
> >
> >
> >
> > EntityManagerFactory emf =
> > Persistence.createEntityManagerFactory("test_db", properties);
> >
> > EntityManager em = emf.createEntityManager();
> >
> >
> >
> > PostgreSQL JDBC Driver support explained that they did the following change
> > in v42.7.5 :
> >
> >
> >
> > https://github.com/apache/openjpa/blob/87e253b9e58a8f061b0431a1ab4df
> > 3e5e1660519/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/ident
> > ifier/DBIdentifierUtilImpl.java#L407-L431
> >
> >
>
> Unfortunately your image was not delivered to the list Please upload
> it to some image-sharing-service and send URL :))
>
> >
> > and since, I can’t use uppercase for the name of the database- L
> >
> > They proposes to find a way in openjpa to preserve case for database name.
> >
> >
> >
> > Thanks for any help.
> >
> > Fred
>
>
>
> --
> Best regards,
> Maxim
--
Best regards,
Maxim
