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/87e253b9e58a8f061b0431a1ab4df3e5e1660519/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/identifier/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
