Hi guys, I finally managed to reproduce it - here's a small application that will generate the provided exception: https://github.com/paranoiabla/hibernate-hsql-issue Please notice that it works fine with Hibernate 4.3.x I think it has to do something with the CommerceCustomerModel - If I remove it or remove the collection of payment infos that is inside of it, it all starts to work fine. Please have a look and thanks a lot for your efforts :) 2015-05-03 1:13 GMT+03:00 Petar Tahchiev <paranoiabla(a)gmail.com&gt;: > Hi guys, > > I just tried hibernate 5.0 beta2 and here's my observations. First of all > the foreign key problems I had before seems to be resolved, however I see > the following error when executing tests with HSQL: > > > Caused by: org.springframework.beans.factory.BeanCreationException: Error > creating bean with name 'defaultEntityManagerFactory' defined in class path > resource [com/nemesis/platform/core/config/PlatformCoreTestConfig.class]: > Invocation of init method failed; nested exception is > javax.persistence.PersistenceException: [PersistenceUnit: default] Unable > to build Hibernate SessionFactory > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195) > at > org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1011) > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:802) > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:521) > at > org.springframework.boot.SpringApplication.refresh(SpringApplication.java:687) > at > org.springframework.boot.SpringApplication.run(SpringApplication.java:321) > at > org.springframework.boot.test.SpringApplicationContextLoader.loadContext(SpringApplicationContextLoader.java:100) > at > org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98) > at > org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116) > ... 36 more > Caused by: javax.persistence.PersistenceException: [PersistenceUnit: > default] Unable to build Hibernate SessionFactory > at > org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:874) > at > org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:802) > at > org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) > at > org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:343) > at > org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:318) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574) > ... 50 more > Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: > Unable to execute schema management to JDBC target [alter table > payment_info add constraint FKs9wud9nve6s9cbot5p4548jyh foreign key > (user_pk) references principal] > at > org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:75) > at > org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlString(SchemaMigratorImpl.java:349) > at > org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlStrings(SchemaMigratorImpl.java:338) > at > org.hibernate.tool.schema.internal.SchemaMigratorImpl.applyForeignKeys(SchemaMigratorImpl.java:303) > at > org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigrationToTargets(SchemaMigratorImpl.java:135) > at > org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:76) > at > org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:146) > at > org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:114) > at > org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:461) > at > org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:462) > at > org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:799) > ... 55 more > Caused by: java.sql.SQLSyntaxErrorException: object name already exists: > FKS9WUD9NVE6S9CBOT5P4548JYH in statement [alter table payment_info add > constraint FKs9wud9nve6s9cbot5p4548jyh foreign key (user_pk) references > principal] > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) > at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) > at > com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:108) > at > com.zaxxer.hikari.proxy.StatementJavassistProxy.executeUpdate(StatementJavassistProxy.java) > at > org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:72) > ... 65 more > Caused by: org.hsqldb.HsqlException: object name already exists: > FKS9WUD9NVE6S9CBOT5P4548JYH > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source) > at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source) > at org.hsqldb.TableWorks.checkCreateForeignKey(Unknown Source) > at org.hsqldb.TableWorks.addForeignKey(Unknown Source) > at org.hsqldb.StatementSchema.getResult(Unknown Source) > at org.hsqldb.StatementSchema.execute(Unknown Source) > at org.hsqldb.Session.executeCompiledStatement(Unknown Source) > at org.hsqldb.Session.executeDirectStatement(Unknown Source) > at org.hsqldb.Session.execute(Unknown Source) > ... 70 more > > > When running it with mysql it doesn't show this error (very strange) so I > tried to export the schema to sql file and I can see only one foregin key > declaration: > > alter table payment_info > add constraint FKs9wud9nve6s9cbot5p4548jyh > foreign key (user_pk) > references principal (pk); > > Notice that this time it is lowercase. I'm trying to debug the hsql but > it is very hard as it doesn't stop on any of the breakpoints I add. If any > of you have an idea what might be causing it, please share your thoughts, > if not I'll let you know how I progress. > > I wonder if it could be related to the duplicate joins warnings I see: > WARN : HHH000072: Duplicate joins for class: > com.nemesis.platform.core.model.media.MediaModel > WARN : HHH000072: Duplicate joins for class: > com.nemesis.platform.module.commerce.core.model.order.TerritoryDeliveryModeValueModel > WARN : HHH000072: Duplicate joins for class: > com.nemesis.platform.core.model.cms.AbstractPageModel > WARN : HHH000072: Duplicate joins for class: > com.nemesis.platform.core.model.cms.EmailPageModel > WARN : HHH000072: Duplicate joins for class: > com.nemesis.platform.core.model.cms.CategoryPageModel > ..... > > -- > Regards, Petar! > Karlovo, Bulgaria. > --- > Public PGP Key at: > https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 > Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 > -- Regards, Petar! Karlovo, Bulgaria. --- Public PGP Key at: https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611

Petar, I have just been focusing on other things the past 3 days or so. Chill :) I will look at this this week. If you happen to have a chance to debug it any further by then, that would rock. FWIW, I do not think it is in any way related to the duplicate secondary table warnings. Those are completely harmless I believe. The FK naming logic has changed quite a bit from pre-5.0 versions, my guess is that the issue lies there. That or in the logic to read existing FKs. On Tue, May 5, 2015 at 3:19 AM, Petar Tahchiev <paranoiabla(a)gmail.com&gt; wrote: > Any of you have seen this issue? Shall I open a ticket? > > 2015-05-04 0:03 GMT+03:00 Petar Tahchiev <paranoiabla(a)gmail.com&gt;: > > > Hi guys, > > > > I finally managed to reproduce it - here's a small application that will > > generate the provided exception: > > > > https://github.com/paranoiabla/hibernate-hsql-issue > > > > Please notice that it works fine with Hibernate 4.3.x I think it has to > > do something with the CommerceCustomerModel - If I remove it or remove > the > > collection of payment infos that is inside of it, it all starts to work > > fine. > > > > Please have a look and thanks a lot for your efforts :) > > > > > > > > > > 2015-05-03 1:13 GMT+03:00 Petar Tahchiev <paranoiabla(a)gmail.com&gt;: > > > >> Hi guys, > >> > >> I just tried hibernate 5.0 beta2 and here's my observations. First of > all > >> the foreign key problems I had before seems to be resolved, however I > see > >> the following error when executing tests with HSQL: > >> > >> > >> Caused by: org.springframework.beans.factory.BeanCreationException: > Error > >> creating bean with name 'defaultEntityManagerFactory' defined in class > path > >> resource > [com/nemesis/platform/core/config/PlatformCoreTestConfig.class]: > >> Invocation of init method failed; nested exception is > >> javax.persistence.PersistenceException: [PersistenceUnit: default] > Unable > >> to build Hibernate SessionFactory > >> at > >> > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578) > >> at > >> > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) > >> at > >> > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) > >> at > >> > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304) > >> at > >> > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) > >> at > >> > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) > >> at > >> > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195) > >> at > >> > org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1011) > >> at > >> > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:802) > >> at > >> > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:521) > >> at > >> > org.springframework.boot.SpringApplication.refresh(SpringApplication.java:687) > >> at > >> > org.springframework.boot.SpringApplication.run(SpringApplication.java:321) > >> at > >> > org.springframework.boot.test.SpringApplicationContextLoader.loadContext(SpringApplicationContextLoader.java:100) > >> at > >> > org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98) > >> at > >> > org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116) > >> ... 36 more > >> Caused by: javax.persistence.PersistenceException: [PersistenceUnit: > >> default] Unable to build Hibernate SessionFactory > >> at > >> > org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:874) > >> at > >> > org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:802) > >> at > >> > org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) > >> at > >> > org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:343) > >> at > >> > org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:318) > >> at > >> > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637) > >> at > >> > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574) > >> ... 50 more > >> Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: > >> Unable to execute schema management to JDBC target [alter table > >> payment_info add constraint FKs9wud9nve6s9cbot5p4548jyh foreign key > >> (user_pk) references principal] > >> at > >> > org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:75) > >> at > >> > org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlString(SchemaMigratorImpl.java:349) > >> at > >> > org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlStrings(SchemaMigratorImpl.java:338) > >> at > >> > org.hibernate.tool.schema.internal.SchemaMigratorImpl.applyForeignKeys(SchemaMigratorImpl.java:303) > >> at > >> > org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigrationToTargets(SchemaMigratorImpl.java:135) > >> at > >> > org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:76) > >> at > >> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:146) > >> at > >> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:114) > >> at > >> > org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:461) > >> at > >> > org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:462) > >> at > >> > org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:799) > >> ... 55 more > >> Caused by: java.sql.SQLSyntaxErrorException: object name already > exists: > >> FKS9WUD9NVE6S9CBOT5P4548JYH in statement [alter table payment_info add > >> constraint FKs9wud9nve6s9cbot5p4548jyh foreign key (user_pk) references > >> principal] > >> at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > >> at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > >> at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) > >> at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) > >> at > >> > com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:108) > >> at > >> > com.zaxxer.hikari.proxy.StatementJavassistProxy.executeUpdate(StatementJavassistProxy.java) > >> at > >> > org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:72) > >> ... 65 more > >> Caused by: org.hsqldb.HsqlException: object name already exists: > >> FKS9WUD9NVE6S9CBOT5P4548JYH > >> at org.hsqldb.error.Error.error(Unknown Source) > >> at org.hsqldb.error.Error.error(Unknown Source) > >> at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source) > >> at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown > Source) > >> at org.hsqldb.TableWorks.checkCreateForeignKey(Unknown Source) > >> at org.hsqldb.TableWorks.addForeignKey(Unknown Source) > >> at org.hsqldb.StatementSchema.getResult(Unknown Source) > >> at org.hsqldb.StatementSchema.execute(Unknown Source) > >> at org.hsqldb.Session.executeCompiledStatement(Unknown Source) > >> at org.hsqldb.Session.executeDirectStatement(Unknown Source) > >> at org.hsqldb.Session.execute(Unknown Source) > >> ... 70 more > >> > >> > >> When running it with mysql it doesn't show this error (very strange) > so I > >> tried to export the schema to sql file and I can see only one foregin > key > >> declaration: > >> > >> alter table payment_info > >> add constraint FKs9wud9nve6s9cbot5p4548jyh > >> foreign key (user_pk) > >> references principal (pk); > >> > >> Notice that this time it is lowercase. I'm trying to debug the hsql but > >> it is very hard as it doesn't stop on any of the breakpoints I add. If > any > >> of you have an idea what might be causing it, please share your > thoughts, > >> if not I'll let you know how I progress. > >> > >> I wonder if it could be related to the duplicate joins warnings I see: > >> WARN : HHH000072: Duplicate joins for class: > >> com.nemesis.platform.core.model.media.MediaModel > >> WARN : HHH000072: Duplicate joins for class: > >> > com.nemesis.platform.module.commerce.core.model.order.TerritoryDeliveryModeValueModel > >> WARN : HHH000072: Duplicate joins for class: > >> com.nemesis.platform.core.model.cms.AbstractPageModel > >> WARN : HHH000072: Duplicate joins for class: > >> com.nemesis.platform.core.model.cms.EmailPageModel > >> WARN : HHH000072: Duplicate joins for class: > >> com.nemesis.platform.core.model.cms.CategoryPageModel > >> ..... > >> > >> -- > >> Regards, Petar! > >> Karlovo, Bulgaria. > >> --- > >> Public PGP Key at: > >> > https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 > >> Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 > >> > > > > > > > > -- > > Regards, Petar! > > Karlovo, Bulgaria. > > --- > > Public PGP Key at: > > > https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 > > Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 > > > > > > -- > Regards, Petar! > Karlovo, Bulgaria. > --- > Public PGP Key at: > https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 > Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 > _______________________________________________ > hibernate-dev mailing list > hibernate-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/hibernate-dev >

Nope. Well, specifically yes your test fails as is. But since you did not simplify your environment, I took that opportunity and simplified it. So I sent you a PR that adds a new test using your model and successfully running an schema update. The only difference is that my test does not have all this unnecessary Spring BS in the mix. So no, I do not thinking this warrants a Hibernate Jira. Until you can simplify this to happen with just Hibernate in the picture. On Wed, May 13, 2015 at 12:59 PM, Petar Tahchiev <paranoiabla(a)gmail.com&gt; wrote: > Any luck on reproducing this? > > 2015-05-05 16:17 GMT+03:00 Steve Ebersole <steve(a)hibernate.org&gt;: > >> Petar, I have just been focusing on other things the past 3 days or so. >> Chill :) >> >> I will look at this this week. If you happen to have a chance to debug >> it any further by then, that would rock. FWIW, I do not think it is in any >> way related to the duplicate secondary table warnings. Those are >> completely harmless I believe. The FK naming logic has changed quite a bit >> from pre-5.0 versions, my guess is that the issue lies there. That or in >> the logic to read existing FKs. >> >> On Tue, May 5, 2015 at 3:19 AM, Petar Tahchiev <paranoiabla(a)gmail.com&gt; >> wrote: >> >>> Any of you have seen this issue? Shall I open a ticket? >>> >>> 2015-05-04 0:03 GMT+03:00 Petar Tahchiev <paranoiabla(a)gmail.com&gt;: >>> >>> > Hi guys, >>> > >>> > I finally managed to reproduce it - here's a small application that >>> will >>> > generate the provided exception: >>> > >>> > https://github.com/paranoiabla/hibernate-hsql-issue >>> > >>> > Please notice that it works fine with Hibernate 4.3.x I think it has >>> to >>> > do something with the CommerceCustomerModel - If I remove it or >>> remove the >>> > collection of payment infos that is inside of it, it all starts to >>> work >>> > fine. >>> > >>> > Please have a look and thanks a lot for your efforts :) >>> > >>> > >>> > >>> > >>> > 2015-05-03 1:13 GMT+03:00 Petar Tahchiev <paranoiabla(a)gmail.com&gt;: >>> > >>> >> Hi guys, >>> >> >>> >> I just tried hibernate 5.0 beta2 and here's my observations. First >>> of all >>> >> the foreign key problems I had before seems to be resolved, however >>> I see >>> >> the following error when executing tests with HSQL: >>> >> >>> >> >>> >> Caused by: org.springframework.beans.factory.BeanCreationException: >>> Error >>> >> creating bean with name 'defaultEntityManagerFactory' defined in >>> class path >>> >> resource >>> [com/nemesis/platform/core/config/PlatformCoreTestConfig.class]: >>> >> Invocation of init method failed; nested exception is >>> >> javax.persistence.PersistenceException: [PersistenceUnit: default] >>> Unable >>> >> to build Hibernate SessionFactory >>> >> at >>> >> >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578) >>> >> at >>> >> >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) >>> >> at >>> >> >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) >>> >> at >>> >> >>> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304) >>> >> at >>> >> >>> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) >>> >> at >>> >> >>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) >>> >> at >>> >> >>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195) >>> >> at >>> >> >>> org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1011) >>> >> at >>> >> >>> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:802) >>> >> at >>> >> >>> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:521) >>> >> at >>> >> >>> org.springframework.boot.SpringApplication.refresh(SpringApplication.java:687) >>> >> at >>> >> >>> org.springframework.boot.SpringApplication.run(SpringApplication.java:321) >>> >> at >>> >> >>> org.springframework.boot.test.SpringApplicationContextLoader.loadContext(SpringApplicationContextLoader.java:100) >>> >> at >>> >> >>> org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98) >>> >> at >>> >> >>> org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116) >>> >> ... 36 more >>> >> Caused by: javax.persistence.PersistenceException: [PersistenceUnit: >>> >> default] Unable to build Hibernate SessionFactory >>> >> at >>> >> >>> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:874) >>> >> at >>> >> >>> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:802) >>> >> at >>> >> >>> org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) >>> >> at >>> >> >>> org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:343) >>> >> at >>> >> >>> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:318) >>> >> at >>> >> >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637) >>> >> at >>> >> >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574) >>> >> ... 50 more >>> >> Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: >>> >> Unable to execute schema management to JDBC target [alter table >>> >> payment_info add constraint FKs9wud9nve6s9cbot5p4548jyh foreign key >>> >> (user_pk) references principal] >>> >> at >>> >> >>> org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:75) >>> >> at >>> >> >>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlString(SchemaMigratorImpl.java:349) >>> >> at >>> >> >>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlStrings(SchemaMigratorImpl.java:338) >>> >> at >>> >> >>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.applyForeignKeys(SchemaMigratorImpl.java:303) >>> >> at >>> >> >>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigrationToTargets(SchemaMigratorImpl.java:135) >>> >> at >>> >> >>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:76) >>> >> at >>> >> >>> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:146) >>> >> at >>> >> >>> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:114) >>> >> at >>> >> >>> org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:461) >>> >> at >>> >> >>> org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:462) >>> >> at >>> >> >>> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:799) >>> >> ... 55 more >>> >> Caused by: java.sql.SQLSyntaxErrorException: object name already >>> exists: >>> >> FKS9WUD9NVE6S9CBOT5P4548JYH in statement [alter table payment_info >>> add >>> >> constraint FKs9wud9nve6s9cbot5p4548jyh foreign key (user_pk) >>> references >>> >> principal] >>> >> at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) >>> >> at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) >>> >> at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) >>> >> at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) >>> >> at >>> >> >>> com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:108) >>> >> at >>> >> >>> com.zaxxer.hikari.proxy.StatementJavassistProxy.executeUpdate(StatementJavassistProxy.java) >>> >> at >>> >> >>> org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:72) >>> >> ... 65 more >>> >> Caused by: org.hsqldb.HsqlException: object name already exists: >>> >> FKS9WUD9NVE6S9CBOT5P4548JYH >>> >> at org.hsqldb.error.Error.error(Unknown Source) >>> >> at org.hsqldb.error.Error.error(Unknown Source) >>> >> at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source) >>> >> at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown >>> Source) >>> >> at org.hsqldb.TableWorks.checkCreateForeignKey(Unknown Source) >>> >> at org.hsqldb.TableWorks.addForeignKey(Unknown Source) >>> >> at org.hsqldb.StatementSchema.getResult(Unknown Source) >>> >> at org.hsqldb.StatementSchema.execute(Unknown Source) >>> >> at org.hsqldb.Session.executeCompiledStatement(Unknown Source) >>> >> at org.hsqldb.Session.executeDirectStatement(Unknown Source) >>> >> at org.hsqldb.Session.execute(Unknown Source) >>> >> ... 70 more >>> >> >>> >> >>> >> When running it with mysql it doesn't show this error (very strange) >>> so I >>> >> tried to export the schema to sql file and I can see only one >>> foregin key >>> >> declaration: >>> >> >>> >> alter table payment_info >>> >> add constraint FKs9wud9nve6s9cbot5p4548jyh >>> >> foreign key (user_pk) >>> >> references principal (pk); >>> >> >>> >> Notice that this time it is lowercase. I'm trying to debug the hsql >>> but >>> >> it is very hard as it doesn't stop on any of the breakpoints I add. >>> If any >>> >> of you have an idea what might be causing it, please share your >>> thoughts, >>> >> if not I'll let you know how I progress. >>> >> >>> >> I wonder if it could be related to the duplicate joins warnings I >>> see: >>> >> WARN : HHH000072: Duplicate joins for class: >>> >> com.nemesis.platform.core.model.media.MediaModel >>> >> WARN : HHH000072: Duplicate joins for class: >>> >> >>> com.nemesis.platform.module.commerce.core.model.order.TerritoryDeliveryModeValueModel >>> >> WARN : HHH000072: Duplicate joins for class: >>> >> com.nemesis.platform.core.model.cms.AbstractPageModel >>> >> WARN : HHH000072: Duplicate joins for class: >>> >> com.nemesis.platform.core.model.cms.EmailPageModel >>> >> WARN : HHH000072: Duplicate joins for class: >>> >> com.nemesis.platform.core.model.cms.CategoryPageModel >>> >> ..... >>> >> >>> >> -- >>> >> Regards, Petar! >>> >> Karlovo, Bulgaria. >>> >> --- >>> >> Public PGP Key at: >>> >> >>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>> >> Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >>> >> >>> > >>> > >>> > >>> > -- >>> > Regards, Petar! >>> > Karlovo, Bulgaria. >>> > --- >>> > Public PGP Key at: >>> > >>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>> > Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >>> > >>> >>> >>> >>> -- >>> Regards, Petar! >>> Karlovo, Bulgaria. >>> --- >>> Public PGP Key at: >>> >>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>> Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >>> _______________________________________________ >>> hibernate-dev mailing list >>> hibernate-dev(a)lists.jboss.org >>> https://lists.jboss.org/mailman/listinfo/hibernate-dev >>> >> >> > > > -- > Regards, Petar! > Karlovo, Bulgaria. > --- > Public PGP Key at: > https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 > Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >

Hi Steve, your test indeed works fine - I logged here https://jira.spring.io/browse/SPR-11694 so that the spring guys will have a look, but I don't think spring is doing any magic on the foreign keys. Juergen Hoeller from spring proposed it might be a bug in Hibernate's EntityManager implementation. I wish we could find out where the problem, but I'm not really that good to investigate further. 2015-05-14 19:27 GMT+03:00 Steve Ebersole <steve(a)hibernate.org&gt;: > No word on the new test case I take it? > > WRT the HHH000072 logged warnings, like i said the warning is inocuous. > But I did correct it: https://hibernate.atlassian.net/browse/HHH-9797 > > On Wed, May 13, 2015 at 3:52 PM, Steve Ebersole <steve(a)hibernate.org&gt; > wrote: > >> Nope. Well, specifically yes your test fails as is. But since you did >> not simplify your environment, I took that opportunity and simplified it. >> So I sent you a PR that adds a new test using your model and successfully >> running an schema update. The only difference is that my test does not >> have all this unnecessary Spring BS in the mix. >> >> So no, I do not thinking this warrants a Hibernate Jira. Until you can >> simplify this to happen with just Hibernate in the picture. >> >> On Wed, May 13, 2015 at 12:59 PM, Petar Tahchiev <paranoiabla(a)gmail.com&gt; >> wrote: >> >>> Any luck on reproducing this? >>> >>> 2015-05-05 16:17 GMT+03:00 Steve Ebersole <steve(a)hibernate.org&gt;: >>> >>>> Petar, I have just been focusing on other things the past 3 days or >>>> so. Chill :) >>>> >>>> I will look at this this week. If you happen to have a chance to >>>> debug it any further by then, that would rock. FWIW, I do not think it is >>>> in any way related to the duplicate secondary table warnings. Those are >>>> completely harmless I believe. The FK naming logic has changed quite a bit >>>> from pre-5.0 versions, my guess is that the issue lies there. That or in >>>> the logic to read existing FKs. >>>> >>>> On Tue, May 5, 2015 at 3:19 AM, Petar Tahchiev <paranoiabla(a)gmail.com&gt; >>>> wrote: >>>> >>>>> Any of you have seen this issue? Shall I open a ticket? >>>>> >>>>> 2015-05-04 0:03 GMT+03:00 Petar Tahchiev <paranoiabla(a)gmail.com&gt;: >>>>> >>>>> > Hi guys, >>>>> > >>>>> > I finally managed to reproduce it - here's a small application that >>>>> will >>>>> > generate the provided exception: >>>>> > >>>>> > https://github.com/paranoiabla/hibernate-hsql-issue >>>>> > >>>>> > Please notice that it works fine with Hibernate 4.3.x I think it >>>>> has to >>>>> > do something with the CommerceCustomerModel - If I remove it or >>>>> remove the >>>>> > collection of payment infos that is inside of it, it all starts to >>>>> work >>>>> > fine. >>>>> > >>>>> > Please have a look and thanks a lot for your efforts :) >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > 2015-05-03 1:13 GMT+03:00 Petar Tahchiev <paranoiabla(a)gmail.com&gt;: >>>>> > >>>>> >> Hi guys, >>>>> >> >>>>> >> I just tried hibernate 5.0 beta2 and here's my observations. First >>>>> of all >>>>> >> the foreign key problems I had before seems to be resolved, >>>>> however I see >>>>> >> the following error when executing tests with HSQL: >>>>> >> >>>>> >> >>>>> >> Caused by: >>>>> org.springframework.beans.factory.BeanCreationException: Error >>>>> >> creating bean with name 'defaultEntityManagerFactory' defined in >>>>> class path >>>>> >> resource >>>>> [com/nemesis/platform/core/config/PlatformCoreTestConfig.class]: >>>>> >> Invocation of init method failed; nested exception is >>>>> >> javax.persistence.PersistenceException: [PersistenceUnit: default] >>>>> Unable >>>>> >> to build Hibernate SessionFactory >>>>> >> at >>>>> >> >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578) >>>>> >> at >>>>> >> >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) >>>>> >> at >>>>> >> >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) >>>>> >> at >>>>> >> >>>>> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304) >>>>> >> at >>>>> >> >>>>> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) >>>>> >> at >>>>> >> >>>>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) >>>>> >> at >>>>> >> >>>>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195) >>>>> >> at >>>>> >> >>>>> org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1011) >>>>> >> at >>>>> >> >>>>> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:802) >>>>> >> at >>>>> >> >>>>> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:521) >>>>> >> at >>>>> >> >>>>> org.springframework.boot.SpringApplication.refresh(SpringApplication.java:687) >>>>> >> at >>>>> >> >>>>> org.springframework.boot.SpringApplication.run(SpringApplication.java:321) >>>>> >> at >>>>> >> >>>>> org.springframework.boot.test.SpringApplicationContextLoader.loadContext(SpringApplicationContextLoader.java:100) >>>>> >> at >>>>> >> >>>>> org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98) >>>>> >> at >>>>> >> >>>>> org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116) >>>>> >> ... 36 more >>>>> >> Caused by: javax.persistence.PersistenceException: >>>>> [PersistenceUnit: >>>>> >> default] Unable to build Hibernate SessionFactory >>>>> >> at >>>>> >> >>>>> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:874) >>>>> >> at >>>>> >> >>>>> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:802) >>>>> >> at >>>>> >> >>>>> org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) >>>>> >> at >>>>> >> >>>>> org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:343) >>>>> >> at >>>>> >> >>>>> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:318) >>>>> >> at >>>>> >> >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637) >>>>> >> at >>>>> >> >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574) >>>>> >> ... 50 more >>>>> >> Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: >>>>> >> Unable to execute schema management to JDBC target [alter table >>>>> >> payment_info add constraint FKs9wud9nve6s9cbot5p4548jyh foreign key >>>>> >> (user_pk) references principal] >>>>> >> at >>>>> >> >>>>> org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:75) >>>>> >> at >>>>> >> >>>>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlString(SchemaMigratorImpl.java:349) >>>>> >> at >>>>> >> >>>>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlStrings(SchemaMigratorImpl.java:338) >>>>> >> at >>>>> >> >>>>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.applyForeignKeys(SchemaMigratorImpl.java:303) >>>>> >> at >>>>> >> >>>>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigrationToTargets(SchemaMigratorImpl.java:135) >>>>> >> at >>>>> >> >>>>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:76) >>>>> >> at >>>>> >> >>>>> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:146) >>>>> >> at >>>>> >> >>>>> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:114) >>>>> >> at >>>>> >> >>>>> org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:461) >>>>> >> at >>>>> >> >>>>> org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:462) >>>>> >> at >>>>> >> >>>>> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:799) >>>>> >> ... 55 more >>>>> >> Caused by: java.sql.SQLSyntaxErrorException: object name already >>>>> exists: >>>>> >> FKS9WUD9NVE6S9CBOT5P4548JYH in statement [alter table payment_info >>>>> add >>>>> >> constraint FKs9wud9nve6s9cbot5p4548jyh foreign key (user_pk) >>>>> references >>>>> >> principal] >>>>> >> at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) >>>>> >> at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) >>>>> >> at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) >>>>> >> at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) >>>>> >> at >>>>> >> >>>>> com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:108) >>>>> >> at >>>>> >> >>>>> com.zaxxer.hikari.proxy.StatementJavassistProxy.executeUpdate(StatementJavassistProxy.java) >>>>> >> at >>>>> >> >>>>> org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:72) >>>>> >> ... 65 more >>>>> >> Caused by: org.hsqldb.HsqlException: object name already exists: >>>>> >> FKS9WUD9NVE6S9CBOT5P4548JYH >>>>> >> at org.hsqldb.error.Error.error(Unknown Source) >>>>> >> at org.hsqldb.error.Error.error(Unknown Source) >>>>> >> at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source) >>>>> >> at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown >>>>> Source) >>>>> >> at org.hsqldb.TableWorks.checkCreateForeignKey(Unknown Source) >>>>> >> at org.hsqldb.TableWorks.addForeignKey(Unknown Source) >>>>> >> at org.hsqldb.StatementSchema.getResult(Unknown Source) >>>>> >> at org.hsqldb.StatementSchema.execute(Unknown Source) >>>>> >> at org.hsqldb.Session.executeCompiledStatement(Unknown Source) >>>>> >> at org.hsqldb.Session.executeDirectStatement(Unknown Source) >>>>> >> at org.hsqldb.Session.execute(Unknown Source) >>>>> >> ... 70 more >>>>> >> >>>>> >> >>>>> >> When running it with mysql it doesn't show this error (very >>>>> strange) so I >>>>> >> tried to export the schema to sql file and I can see only one >>>>> foregin key >>>>> >> declaration: >>>>> >> >>>>> >> alter table payment_info >>>>> >> add constraint FKs9wud9nve6s9cbot5p4548jyh >>>>> >> foreign key (user_pk) >>>>> >> references principal (pk); >>>>> >> >>>>> >> Notice that this time it is lowercase. I'm trying to debug the >>>>> hsql but >>>>> >> it is very hard as it doesn't stop on any of the breakpoints I >>>>> add. If any >>>>> >> of you have an idea what might be causing it, please share your >>>>> thoughts, >>>>> >> if not I'll let you know how I progress. >>>>> >> >>>>> >> I wonder if it could be related to the duplicate joins warnings I >>>>> see: >>>>> >> WARN : HHH000072: Duplicate joins for class: >>>>> >> com.nemesis.platform.core.model.media.MediaModel >>>>> >> WARN : HHH000072: Duplicate joins for class: >>>>> >> >>>>> com.nemesis.platform.module.commerce.core.model.order.TerritoryDeliveryModeValueModel >>>>> >> WARN : HHH000072: Duplicate joins for class: >>>>> >> com.nemesis.platform.core.model.cms.AbstractPageModel >>>>> >> WARN : HHH000072: Duplicate joins for class: >>>>> >> com.nemesis.platform.core.model.cms.EmailPageModel >>>>> >> WARN : HHH000072: Duplicate joins for class: >>>>> >> com.nemesis.platform.core.model.cms.CategoryPageModel >>>>> >> ..... >>>>> >> >>>>> >> -- >>>>> >> Regards, Petar! >>>>> >> Karlovo, Bulgaria. >>>>> >> --- >>>>> >> Public PGP Key at: >>>>> >> >>>>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>>>> >> Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >>>>> >> >>>>> > >>>>> > >>>>> > >>>>> > -- >>>>> > Regards, Petar! >>>>> > Karlovo, Bulgaria. >>>>> > --- >>>>> > Public PGP Key at: >>>>> > >>>>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>>>> > Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >>>>> > >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards, Petar! >>>>> Karlovo, Bulgaria. >>>>> --- >>>>> Public PGP Key at: >>>>> >>>>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>>>> Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >>>>> _______________________________________________ >>>>> hibernate-dev mailing list >>>>> hibernate-dev(a)lists.jboss.org >>>>> https://lists.jboss.org/mailman/listinfo/hibernate-dev >>>>> >>>> >>>> >>> >>> >>> -- >>> Regards, Petar! >>> Karlovo, Bulgaria. >>> --- >>> Public PGP Key at: >>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>> Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >>> >> >> > -- Regards, Petar! Karlovo, Bulgaria. --- Public PGP Key at: https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611

Actually that cannot be it. JPA does not define schema update capability. On May 14, 2015 4:27 PM, "Steve Ebersole" <steve(a)hibernate.org&gt; wrote: > So you're original test was using JPA? See this illustrates why it's > best to isolate tests down to SSCCE. > > I will try again with JPA specifically. > On May 14, 2015 11:30 AM, "Petar Tahchiev" <paranoiabla(a)gmail.com&gt; wrote: > >> Hi Steve, >> >> your test indeed works fine - I logged here >> https://jira.spring.io/browse/SPR-11694 so that the spring guys will >> have a look, but I don't think spring is doing any magic on the foreign >> keys. Juergen Hoeller from spring proposed it might be a bug in >> Hibernate's EntityManager implementation. >> >> I wish we could find out where the problem, but I'm not really that good >> to investigate further. >> >> 2015-05-14 19:27 GMT+03:00 Steve Ebersole <steve(a)hibernate.org&gt;: >> >>> No word on the new test case I take it? >>> >>> WRT the HHH000072 logged warnings, like i said the warning is >>> inocuous. But I did correct it: >>> https://hibernate.atlassian.net/browse/HHH-9797 >>> >>> On Wed, May 13, 2015 at 3:52 PM, Steve Ebersole <steve(a)hibernate.org&gt; >>> wrote: >>> >>>> Nope. Well, specifically yes your test fails as is. But since you >>>> did not simplify your environment, I took that opportunity and simplified >>>> it. So I sent you a PR that adds a new test using your model and >>>> successfully running an schema update. The only difference is that my test >>>> does not have all this unnecessary Spring BS in the mix. >>>> >>>> So no, I do not thinking this warrants a Hibernate Jira. Until you >>>> can simplify this to happen with just Hibernate in the picture. >>>> >>>> On Wed, May 13, 2015 at 12:59 PM, Petar Tahchiev < >>>> paranoiabla(a)gmail.com&gt; wrote: >>>> >>>>> Any luck on reproducing this? >>>>> >>>>> 2015-05-05 16:17 GMT+03:00 Steve Ebersole <steve(a)hibernate.org&gt;: >>>>> >>>>>> Petar, I have just been focusing on other things the past 3 days or >>>>>> so. Chill :) >>>>>> >>>>>> I will look at this this week. If you happen to have a chance to >>>>>> debug it any further by then, that would rock. FWIW, I do not think it is >>>>>> in any way related to the duplicate secondary table warnings. Those are >>>>>> completely harmless I believe. The FK naming logic has changed quite a bit >>>>>> from pre-5.0 versions, my guess is that the issue lies there. That or in >>>>>> the logic to read existing FKs. >>>>>> >>>>>> On Tue, May 5, 2015 at 3:19 AM, Petar Tahchiev < >>>>>> paranoiabla(a)gmail.com&gt; wrote: >>>>>> >>>>>>> Any of you have seen this issue? Shall I open a ticket? >>>>>>> >>>>>>> 2015-05-04 0:03 GMT+03:00 Petar Tahchiev <paranoiabla(a)gmail.com&gt;: >>>>>>> >>>>>>> > Hi guys, >>>>>>> > >>>>>>> > I finally managed to reproduce it - here's a small application >>>>>>> that will >>>>>>> > generate the provided exception: >>>>>>> > >>>>>>> > https://github.com/paranoiabla/hibernate-hsql-issue >>>>>>> > >>>>>>> > Please notice that it works fine with Hibernate 4.3.x I think it >>>>>>> has to >>>>>>> > do something with the CommerceCustomerModel - If I remove it or >>>>>>> remove the >>>>>>> > collection of payment infos that is inside of it, it all starts >>>>>>> to work >>>>>>> > fine. >>>>>>> > >>>>>>> > Please have a look and thanks a lot for your efforts :) >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > 2015-05-03 1:13 GMT+03:00 Petar Tahchiev <paranoiabla(a)gmail.com&gt;: >>>>>>> > >>>>>>> >> Hi guys, >>>>>>> >> >>>>>>> >> I just tried hibernate 5.0 beta2 and here's my observations. >>>>>>> First of all >>>>>>> >> the foreign key problems I had before seems to be resolved, >>>>>>> however I see >>>>>>> >> the following error when executing tests with HSQL: >>>>>>> >> >>>>>>> >> >>>>>>> >> Caused by: >>>>>>> org.springframework.beans.factory.BeanCreationException: Error >>>>>>> >> creating bean with name 'defaultEntityManagerFactory' defined in >>>>>>> class path >>>>>>> >> resource >>>>>>> [com/nemesis/platform/core/config/PlatformCoreTestConfig.class]: >>>>>>> >> Invocation of init method failed; nested exception is >>>>>>> >> javax.persistence.PersistenceException: [PersistenceUnit: >>>>>>> default] Unable >>>>>>> >> to build Hibernate SessionFactory >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1011) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:802) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:521) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.boot.SpringApplication.refresh(SpringApplication.java:687) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.boot.SpringApplication.run(SpringApplication.java:321) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.boot.test.SpringApplicationContextLoader.loadContext(SpringApplicationContextLoader.java:100) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116) >>>>>>> >> ... 36 more >>>>>>> >> Caused by: javax.persistence.PersistenceException: >>>>>>> [PersistenceUnit: >>>>>>> >> default] Unable to build Hibernate SessionFactory >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:874) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:802) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:343) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:318) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637) >>>>>>> >> at >>>>>>> >> >>>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574) >>>>>>> >> ... 50 more >>>>>>> >> Caused by: >>>>>>> org.hibernate.tool.schema.spi.SchemaManagementException: >>>>>>> >> Unable to execute schema management to JDBC target [alter table >>>>>>> >> payment_info add constraint FKs9wud9nve6s9cbot5p4548jyh foreign >>>>>>> key >>>>>>> >> (user_pk) references principal] >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:75) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlString(SchemaMigratorImpl.java:349) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlStrings(SchemaMigratorImpl.java:338) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.applyForeignKeys(SchemaMigratorImpl.java:303) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigrationToTargets(SchemaMigratorImpl.java:135) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:76) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:146) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:114) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:461) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:462) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:799) >>>>>>> >> ... 55 more >>>>>>> >> Caused by: java.sql.SQLSyntaxErrorException: object name already >>>>>>> exists: >>>>>>> >> FKS9WUD9NVE6S9CBOT5P4548JYH in statement [alter table >>>>>>> payment_info add >>>>>>> >> constraint FKs9wud9nve6s9cbot5p4548jyh foreign key (user_pk) >>>>>>> references >>>>>>> >> principal] >>>>>>> >> at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) >>>>>>> >> at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) >>>>>>> >> at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) >>>>>>> >> at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown >>>>>>> Source) >>>>>>> >> at >>>>>>> >> >>>>>>> com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:108) >>>>>>> >> at >>>>>>> >> >>>>>>> com.zaxxer.hikari.proxy.StatementJavassistProxy.executeUpdate(StatementJavassistProxy.java) >>>>>>> >> at >>>>>>> >> >>>>>>> org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:72) >>>>>>> >> ... 65 more >>>>>>> >> Caused by: org.hsqldb.HsqlException: object name already exists: >>>>>>> >> FKS9WUD9NVE6S9CBOT5P4548JYH >>>>>>> >> at org.hsqldb.error.Error.error(Unknown Source) >>>>>>> >> at org.hsqldb.error.Error.error(Unknown Source) >>>>>>> >> at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source) >>>>>>> >> at >>>>>>> org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source) >>>>>>> >> at org.hsqldb.TableWorks.checkCreateForeignKey(Unknown >>>>>>> Source) >>>>>>> >> at org.hsqldb.TableWorks.addForeignKey(Unknown Source) >>>>>>> >> at org.hsqldb.StatementSchema.getResult(Unknown Source) >>>>>>> >> at org.hsqldb.StatementSchema.execute(Unknown Source) >>>>>>> >> at org.hsqldb.Session.executeCompiledStatement(Unknown >>>>>>> Source) >>>>>>> >> at org.hsqldb.Session.executeDirectStatement(Unknown Source) >>>>>>> >> at org.hsqldb.Session.execute(Unknown Source) >>>>>>> >> ... 70 more >>>>>>> >> >>>>>>> >> >>>>>>> >> When running it with mysql it doesn't show this error (very >>>>>>> strange) so I >>>>>>> >> tried to export the schema to sql file and I can see only one >>>>>>> foregin key >>>>>>> >> declaration: >>>>>>> >> >>>>>>> >> alter table payment_info >>>>>>> >> add constraint FKs9wud9nve6s9cbot5p4548jyh >>>>>>> >> foreign key (user_pk) >>>>>>> >> references principal (pk); >>>>>>> >> >>>>>>> >> Notice that this time it is lowercase. I'm trying to debug the >>>>>>> hsql but >>>>>>> >> it is very hard as it doesn't stop on any of the breakpoints I >>>>>>> add. If any >>>>>>> >> of you have an idea what might be causing it, please share your >>>>>>> thoughts, >>>>>>> >> if not I'll let you know how I progress. >>>>>>> >> >>>>>>> >> I wonder if it could be related to the duplicate joins warnings >>>>>>> I see: >>>>>>> >> WARN : HHH000072: Duplicate joins for class: >>>>>>> >> com.nemesis.platform.core.model.media.MediaModel >>>>>>> >> WARN : HHH000072: Duplicate joins for class: >>>>>>> >> >>>>>>> com.nemesis.platform.module.commerce.core.model.order.TerritoryDeliveryModeValueModel >>>>>>> >> WARN : HHH000072: Duplicate joins for class: >>>>>>> >> com.nemesis.platform.core.model.cms.AbstractPageModel >>>>>>> >> WARN : HHH000072: Duplicate joins for class: >>>>>>> >> com.nemesis.platform.core.model.cms.EmailPageModel >>>>>>> >> WARN : HHH000072: Duplicate joins for class: >>>>>>> >> com.nemesis.platform.core.model.cms.CategoryPageModel >>>>>>> >> ..... >>>>>>> >> >>>>>>> >> -- >>>>>>> >> Regards, Petar! >>>>>>> >> Karlovo, Bulgaria. >>>>>>> >> --- >>>>>>> >> Public PGP Key at: >>>>>>> >> >>>>>>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>>>>>> >> Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 >>>>>>> 0611 >>>>>>> >> >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > -- >>>>>>> > Regards, Petar! >>>>>>> > Karlovo, Bulgaria. >>>>>>> > --- >>>>>>> > Public PGP Key at: >>>>>>> > >>>>>>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>>>>>> > Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 >>>>>>> 0611 >>>>>>> > >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Regards, Petar! >>>>>>> Karlovo, Bulgaria. >>>>>>> --- >>>>>>> Public PGP Key at: >>>>>>> >>>>>>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>>>>>> Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >>>>>>> _______________________________________________ >>>>>>> hibernate-dev mailing list >>>>>>> hibernate-dev(a)lists.jboss.org >>>>>>> https://lists.jboss.org/mailman/listinfo/hibernate-dev >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Regards, Petar! >>>>> Karlovo, Bulgaria. >>>>> --- >>>>> Public PGP Key at: >>>>> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >>>>> Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >>>>> >>>> >>>> >>> >> >> >> -- >> Regards, Petar! >> Karlovo, Bulgaria. >> --- >> Public PGP Key at: >> https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611 >> Key Fingerprint: A369 A7EE 61BC 93A3 CDFF 55A5 1965 8550 C311 0611 >> >