Demosite 3 throwing exceptions during startup
Posted: Fri Jun 28, 2013 3:27 am
I followed the instruction on getting started page. However when I try to run the site on mysql using jetty-demo-no-db getting below db exceptions
and the application is not started. I receive 404 when I hit the url
Hibernate: create table SEQUENCE_GENERATOR ( ID_NAME varchar(255) not null , ID_VAL bigint, primary key ( ID_NAME ) )
[artifact:mvn] [ERROR] 13:46:54 SchemaExport - HHH000231: Schema export unsuccessful
[artifact:mvn] org.hibernate.tool.hbm2ddl.ImportScriptException: Error during statement execution (file: '/sql/load_content_structure_i18n.sql'): INSERT INTO BLC_PGTMPLT_FLDGRP_XREF(PAGE_TMPLT_ID, FLD_GROUP_ID, GROUP_ORDER) VALUES (2,1,0)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:451)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:378)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:304)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:293)
[artifact:mvn] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:498)
[artifact:mvn] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1743)
[artifact:mvn] at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:94)
[artifact:mvn] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:905)
------
-----
[artifact:mvn] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`broadleaf`.`blc_pgtmplt_fldgrp_xref`, CONSTRAINT `FK99D625F66A79BDB5` FOREIGN KEY (`FLD_GROUP_ID`) REFERENCES `blc_fld_group` (`FLD_GROUP_ID`))
[artifact:mvn] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[artifact:mvn] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
[artifact:mvn] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
[artifact:mvn] at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
[artifact:mvn] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
[artifact:mvn] at com.mysql.jdbc.Util.getInstance(Util.java:386)
[artifact:mvn] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
and the application is not started. I receive 404 when I hit the url
Hibernate: create table SEQUENCE_GENERATOR ( ID_NAME varchar(255) not null , ID_VAL bigint, primary key ( ID_NAME ) )
[artifact:mvn] [ERROR] 13:46:54 SchemaExport - HHH000231: Schema export unsuccessful
[artifact:mvn] org.hibernate.tool.hbm2ddl.ImportScriptException: Error during statement execution (file: '/sql/load_content_structure_i18n.sql'): INSERT INTO BLC_PGTMPLT_FLDGRP_XREF(PAGE_TMPLT_ID, FLD_GROUP_ID, GROUP_ORDER) VALUES (2,1,0)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:451)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:378)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:304)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:293)
[artifact:mvn] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:498)
[artifact:mvn] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1743)
[artifact:mvn] at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:94)
[artifact:mvn] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:905)
------
-----
[artifact:mvn] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`broadleaf`.`blc_pgtmplt_fldgrp_xref`, CONSTRAINT `FK99D625F66A79BDB5` FOREIGN KEY (`FLD_GROUP_ID`) REFERENCES `blc_fld_group` (`FLD_GROUP_ID`))
[artifact:mvn] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[artifact:mvn] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
[artifact:mvn] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
[artifact:mvn] at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
[artifact:mvn] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
[artifact:mvn] at com.mysql.jdbc.Util.getInstance(Util.java:386)
[artifact:mvn] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)