Hi Sorry for my late reply, got caught up by work and stuff.
No, that is not the problem. I tried removing the spring app module, which removed the duplicate and the problem was still there. I will try to see if I can reproduce it from command line, so I can debug/turn on some more hibernate logging, then I will revert. Best regards Jens On Wednesday, September 18, 2019 at 5:33:44 PM UTC+2, Lukas Eder wrote: > > Well, one thing that can be said here is that you have two hibernates on > the classpath, which you can see when you run "mvn dependency:tree > -Dverbose" > > - org.hibernate:hibernate-core:jar:5.3.10.Final > - org.hibernate:hibernate-core:jar:5.4.2.Final > > Perhaps that helps? > > On Wed, Sep 18, 2019 at 4:03 PM Jens Teglhus Møller < > [email protected] <javascript:>> wrote: > >> Hi Lukas >> >> Thanks for your answer. I managed to get it to build with your suggested >> dependency changes. >> >> But it did not affect the resulting table names. In the example I would >> expect the entity SampleTable to become SAMPLE_TABLE (it does when creating >> the database through a spring boot application) but it ends up as >> SAMPLETABLE. >> >> When running maven build build with -X flag i get the following >> interesting output: >> >> [DEBUG] Executing query : select >> "INFORMATION_SCHEMA"."TABLES"."TABLE_SCHEMA", >> "INFORMATION_SCHEMA"."TABLES"."TABLE_NAME", >> "INFORMATION_SCHEMA"."TABLES"."REMARKS" from "INFORMATION_SCHEMA"."TABLES" >> where "INFORMATION_SCHEMA"."TABLES"."TABLE_SCHEMA" in (cast(? as varchar)) >> order by "INFORMATION_SCHEMA"."TABLES"."TABLE_SCHEMA", >> "INFORMATION_SCHEMA"."TABLES"."TABLE_NAME" >> [DEBUG] -> with bind values : select >> "INFORMATION_SCHEMA"."TABLES"."TABLE_SCHEMA", >> "INFORMATION_SCHEMA"."TABLES"."TABLE_NAME", >> "INFORMATION_SCHEMA"."TABLES"."REMARKS" from "INFORMATION_SCHEMA"."TABLES" >> where "INFORMATION_SCHEMA"."TABLES"."TABLE_SCHEMA" in ('PUBLIC') order by >> "INFORMATION_SCHEMA"."TABLES"."TABLE_SCHEMA", >> "INFORMATION_SCHEMA"."TABLES"."TABLE_NAME" >> [DEBUG] Fetched result : +------------+------------+-------+ >> [DEBUG] : |TABLE_SCHEMA|TABLE_NAME |REMARKS| >> [DEBUG] : +------------+------------+-------+ >> [DEBUG] : |PUBLIC |SAMPLETABLE | | >> [DEBUG] : |PUBLIC |SAMPLE_TABLE| | >> [DEBUG] : +------------+------------+-------+ >> [DEBUG] Fetched row(s) : 2 >> [DEBUG] Include : Including PUBLIC.SAMPLETABLE because >> of pattern .* >> [WARNING] Ambiguous type name : The object SAMPLE_TABLE generates a >> type jooqexample.jooqmodel.tables.SampleTable which conflicts with the >> existing type jooqexample.jooqmodel.tables.Sampletable on some operating >> systems. Use a custom generator strategy to disambiguate the types. >> [DEBUG] Exclude : Excluding PUBLIC.SAMPLE_TABLE because >> of filter >> org.jooq.codegen.JavaGenerator$AvoidAmbiguousClassesFilter@48a46b0f >> [INFO] Tables fetched : 2 (1 included, 1 excluded) >> >> Any clues as to why hibernate creates both SAMPLETABLE & SAMPLE_TABLE? >> >> Best regards Jens >> >> On Tuesday, September 17, 2019 at 10:57:16 AM UTC+2, Jens Teglhus Møller >> wrote: >>> >>> Hi >>> >>> I'm trying to get schema generation using JPADatabase to work with >>> spring boot. >>> >>> In my initial testing I got everything working to the point where there >>> was a mismatch with the table names when executing queries (generator not >>> using same naming strategy as spring app). >>> >>> I have a 3 module maven setup with jpa-model, jooq-model and spring-app >>> (simplified example can be seen here: >>> https://github.com/djarnis73/jooq-spring-jpa-example). >>> >>> I saw the documentation regarding >>> setting >>> hibernate.physical_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy >>> >>> but when i do that the code generator fails since it cannot find the class. >>> >>> [ERROR] Failed to execute goal >>> org.jooq:jooq-codegen-maven:3.12.1:generate (default) on project >>> jooq-model: Error running jOOQ code generation tool: Error while exporting >>> schema: Unable to resolve name >>> [org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy] >>> as strategy [org.hibernate.boot.model.naming.PhysicalNamingStrategy]: >>> Unable to load class >>> [org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy]: >>> Could not load requested class : >>> org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy -> >>> [Help 1] >>> >>> I tried adding >>> >>> <dependency> >>> <groupId>org.springframework.boot</groupId> >>> <artifactId>spring-boot</artifactId> >>> <version>${spring.boot.version}</version> >>> </dependency> >>> >>> I also tried adding the dependency several other places, but I think it >>> should be a plugin dependency. >>> >>> I have verified that >>> org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy is >>> in the org.springframework.boot:spring-boot jar file >>> >>> And when running maven with -X i get the following: >>> >>> [DEBUG] Populating class realm plugin>org.jooq:jooq-codegen-maven:3.12.1 >>> [DEBUG] Included: org.jooq:jooq-codegen-maven:jar:3.12.1 >>> [DEBUG] Included: >>> org.springframework.boot:spring-boot:jar:2.1.8.RELEASE >>> (others removed for brevity) >>> >>> I'm testing with jooq 3.12.1, spring boot 2.1.8.RELEASE >>> >>> I have not been able to get it working, can anyone give me a hint or >>> point me to a working example. >>> >>> Best regards Jens >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "jOOQ User Group" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jooq-user/9af136d7-e1ae-4d18-b1a4-ff10b2189023%40googlegroups.com >> >> <https://groups.google.com/d/msgid/jooq-user/9af136d7-e1ae-4d18-b1a4-ff10b2189023%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/ad30c42e-0b09-4fc0-af67-330a6da8ca42%40googlegroups.com.
