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" <paranoia...@gmail.com> 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 <st...@hibernate.org>: > >> 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 <st...@hibernate.org> >> 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 <paranoia...@gmail.com> >>> wrote: >>> >>>> Any luck on reproducing this? >>>> >>>> 2015-05-05 16:17 GMT+03:00 Steve Ebersole <st...@hibernate.org>: >>>> >>>>> 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 <paranoia...@gmail.com> >>>>> wrote: >>>>> >>>>>> Any of you have seen this issue? Shall I open a ticket? >>>>>> >>>>>> 2015-05-04 0:03 GMT+03:00 Petar Tahchiev <paranoia...@gmail.com>: >>>>>> >>>>>> > 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 <paranoia...@gmail.com>: >>>>>> > >>>>>> >> 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@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 > _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
