1 Reply Latest reply on Apr 19, 2017 8:56 AM by valsaraj007

    SchemaExtractionException: More than one table found in namespace in WildFly 10.1

    valsaraj007

      I am facing issue with old DB when migrated from wildfly-8.2 to wildfly-10.1:

       

      Unable to build Hibernate SessionFactory

      ...

      Caused by: org.hibernate.tool.schema.extract.spi. (, )

       

      Any suggestions to fix this?

      It looks like wildfly-10.1 hiberbate version hit [HHH-10718] Underscore in table name can result in SchemaExtractionException: More than one table found - Hibernate JIRA

      What is the step to upgrade hibernate in wildfly-10.1?

       

      Thanks!

        • 1. Re: SchemaExtractionException: More than one table found in namespace in WildFly 10.1
          valsaraj007

          The above exception gone when upgraded to hibernate 5.1.5. But facing this exception: WildFly 10.1 Hibernate SchemaManagementException

          2017-04-19 18:10:30,113 WARN  [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] (ServerService Thread Pool -- 86) GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement: org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement

          ...

          Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "author_info" violates foreign key constraint "fk8dmiogojwntxbw5acljojkvan"

            Detail: Key (author_id)=(5967) is not present in table "author".

          1 of 1 people found this helpful