re-sending with modified email of TS :) On Thu, 14 Aug 2025 at 11:44, Maxim Solodovnik <[email protected]> wrote: > > Hello Fred, > > welcome to the list :) > > > On Wed, 13 Aug 2025 at 13:35, MONCLAR Frederic > <[email protected]> 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 [email protected] 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
-- Best regards, Maxim
