Page 2 of 3

Re: Moving DataBase HSQLDB to MySQL

Posted: Sun Oct 07, 2012 9:59 pm
by mota_nginya
This is not related except for the title. I followed the instruction http://docs.broadleafcommerce.org/curre ... orial.html but I am getting the error listed below although it does not prevent the app from starting but seeing errors throws me off. Plus it may be further problems down the road. What am I missing here?

Code: Select all

[ERROR] 21:45:03 Ejb3Configuration - Container is providing a null PersistenceUnitRootUrl: discovery impossible
[ WARN] 21:45:03 Ejb3Configuration - hibernate.connection.autocommit = false break the EJB3 specification
[ERROR] 21:45:03 SchemaUpdate - could not get database metadata
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'system_sequences' in information_schema
   at sun.reflect.GeneratedConstructorAccessor75.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
   at com.mysql.jdbc.Util.getInstance(Util.java:386)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2663)
   at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1599)
   at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:151)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:69)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:62)
   at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:170)
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:375)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1872)
   at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906)
   at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
   at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:268)
   at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:310)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:567)
   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
   at org.broadleafcommerce.common.web.extensibility.MergeContextLoaderListener.contextInitialized(MergeContextLoaderListener.java:42)
   at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:766)
   at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:406)
   at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:758)
   at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:242)
   at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1233)
   at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:701)
   at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:475)
   at org.mortbay.jetty.plugin.JettyWebAppContext.doStart(JettyWebAppContext.java:256)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)
   at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:167)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90)
   at org.eclipse.jetty.server.Server.doStart(Server.java:272)
   at org.mortbay.jetty.plugin.JettyServer.doStart(JettyServer.java:65)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.mortbay.jetty.plugin.AbstractJettyMojo.startJetty(AbstractJettyMojo.java:511)
   at org.mortbay.jetty.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.java:364)
   at org.mortbay.jetty.plugin.JettyRunMojo.execute(JettyRunMojo.java:516)
   at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
   at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
   at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
   at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
   at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
   at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
   at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
   at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
   at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
   at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
   at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
   at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
   at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
   at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
   at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
   at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
[ERROR] 21:45:03 SchemaUpdate - could not complete schema update
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'system_sequences' in information_schema
   at sun.reflect.GeneratedConstructorAccessor75.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
   at com.mysql.jdbc.Util.getInstance(Util.java:386)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2663)
   at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1599)
   at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:151)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:69)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:62)
   at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:170)
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:375)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1872)
   at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906)
   at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
   at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:268)
   at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:310)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:567)
   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
   at org.broadleafcommerce.common.web.extensibility.MergeContextLoaderListener.contextInitialized(MergeContextLoaderListener.java:42)
   at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:766)
   at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:406)
   at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:758)
   at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:242)
   at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1233)
   at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:701)
   at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:475)
   at org.mortbay.jetty.plugin.JettyWebAppContext.doStart(JettyWebAppContext.java:256)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)
   at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:167)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90)
   at org.eclipse.jetty.server.Server.doStart(Server.java:272)
   at org.mortbay.jetty.plugin.JettyServer.doStart(JettyServer.java:65)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.mortbay.jetty.plugin.AbstractJettyMojo.startJetty(AbstractJettyMojo.java:511)
   at org.mortbay.jetty.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.java:364)
   at org.mortbay.jetty.plugin.JettyRunMojo.execute(JettyRunMojo.java:516)
   at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
   at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
   at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
   at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
   at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
   at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
   at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
   at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
   at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
   at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
   at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
   at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
   at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
   at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
   at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
   at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
[ WARN] 21:45:11 IndexSchema - no uniqueKey specified in schema.
[ERROR] 21:45:17 Ejb3Configuration - Container is providing a null PersistenceUnitRootUrl: discovery impossible
[ WARN] 21:45:18 Ejb3Configuration - hibernate.connection.autocommit = false break the EJB3 specification
[ERROR] 21:45:18 SchemaExport - Unsuccessful: create table BLC_STATIC_ASSET_STRG (STATIC_ASSET_STRG_ID bigint not null, FILE_DATA blob, STATIC_ASSET_ID bigint not null, primary key (STATIC_ASSET_STRG_ID))
[ERROR] 21:45:18 SchemaExport - Table 'blc_static_asset_strg' already exists
[ERROR] 21:45:18 SchemaExport - Unsuccessful: create index STATIC_ASSET_ID_INDEX on BLC_STATIC_ASSET_STRG (STATIC_ASSET_ID)
[ERROR] 21:45:18 SchemaExport - Duplicate key name 'STATIC_ASSET_ID_INDEX'
[ERROR] 21:45:18 SchemaExport - Unsuccessful: create table SEQUENCE_GENERATOR ( ID_NAME varchar(255) not null ,  ID_VAL bigint, primary key ( ID_NAME ) )
[ERROR] 21:45:18 SchemaExport - Table 'sequence_generator' already exists
[ERROR] 21:45:18 SchemaExport - schema export unsuccessful
org.hibernate.JDBCException: Error during import script execution at line 4
   at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:370)
   at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:276)
   at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:219)
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:372)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1872)
   at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906)
   at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
   at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:268)
   at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:310)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
   at org.springframework.orm.jpa.EntityManagerFactoryUtils.findEntityManagerFactory(EntityManagerFactoryUtils.java:99)
   at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findNamedEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:511)
   at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:493)
   at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.resolveEntityManager(PersistenceAnnotationBeanPostProcessor.java:657)
   at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.getResourceToInject(PersistenceAnnotationBeanPostProcessor.java:630)
   at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150)
   at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
   at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessPropertyValues(PersistenceAnnotationBeanPostProcessor.java:339)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549)
   at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150)
   at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549)
   at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150)
   at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549)
   at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150)
   at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549)
   at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150)
   at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
   at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
   at org.broadleafcommerce.common.web.extensibility.MergeContextLoaderListener.contextInitialized(MergeContextLoaderListener.java:42)
   at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:766)
   at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:406)
   at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:758)
   at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:242)
   at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1233)
   at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:701)
   at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:475)
   at org.mortbay.jetty.plugin.JettyWebAppContext.doStart(JettyWebAppContext.java:256)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)
   at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:167)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90)
   at org.eclipse.jetty.server.Server.doStart(Server.java:272)
   at org.mortbay.jetty.plugin.JettyServer.doStart(JettyServer.java:65)
   at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
   at org.mortbay.jetty.plugin.AbstractJettyMojo.startJetty(AbstractJettyMojo.java:511)
   at org.mortbay.jetty.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.java:364)
   at org.mortbay.jetty.plugin.JettyRunMojo.execute(JettyRunMojo.java:516)
   at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
   at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
   at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
   at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
   at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
   at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
   at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
   at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
   at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
   at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
   at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
   at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
   at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
   at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
   at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
   at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'CustomerId' for key 'PRIMARY'
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
   at com.mysql.jdbc.Util.getInstance(Util.java:386)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2663)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:888)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:730)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:366)
   ... 131 more


This is the file that I changed and also added my sql jar in the application. Everything builds and runs but like I said above I am seeing the aforementioned errors on both the admin and the site modules.

Code: Select all

<?xml version="1.0"?>
<!DOCTYPE Configure PUBLIC "-//Mort Bay Consulting//DTD Configure//EN" "http://jetty.mortbay.org/configure.dtd">

<!-- THIS IS FOR RUNNING IN local OR development MODE ONLY! IT WILL AUTOMATICALLY BE USED IN A
JETTY ENVIRONMENT. YOU SHOULD SET UP JNDI ACCORDING TO YOUR SERVER'S DOCUMENTATION AND USE THAT.
IT IS NOT RECOMMENDED TO USE JETTY IN A PRODUCTION ENVIRONMENT.
-->
<Configure class="org.eclipse.jetty.webapp.WebAppContext">

   <!-- Add an EnvEntry only valid for this webapp -->
   <New id="appName" class="org.eclipse.jetty.plus.jndi.EnvEntry">
      <Arg>appName</Arg>
      <Arg type="java.lang.String">sakotek-site</Arg>
      <Arg type="boolean">true</Arg>
   </New>
   
      <New id="webDS" class="org.eclipse.jetty.plus.jndi.Resource">
      <Arg>jdbc/web</Arg>
      <Arg>
         <New class="org.apache.commons.dbcp.BasicDataSource">
            <Set name="driverClassName">com.mysql.jdbc.Driver</Set>
            <Set name="url">jdbc:mysql://localhost:3306/ndongoredb</Set>
            <Set name="username">root</Set>
            <Set name="password"></Set>
         </New>
      </Arg>
   </New>

    <New id="webSecureDS" class="org.eclipse.jetty.plus.jndi.Resource">
        <Arg>jdbc/secure</Arg>
        <Arg>
            <New class="org.apache.commons.dbcp.BasicDataSource">
            <Set name="driverClassName">com.mysql.jdbc.Driver</Set>
            <Set name="url">jdbc:mysql://localhost:3306/ndongoredb</Set>
            <Set name="username">root</Set>
            <Set name="password"></Set>
         </New>
        </Arg>
    </New>

    <New id="webStorageDS" class="org.eclipse.jetty.plus.jndi.Resource">
        <Arg>jdbc/storage</Arg>
        <Arg>
            <New class="org.apache.commons.dbcp.BasicDataSource">
            <Set name="driverClassName">com.mysql.jdbc.Driver</Set>
            <Set name="url">jdbc:mysql://localhost:3306/ndongoredb</Set>
            <Set name="username">root</Set>
            <Set name="password"></Set>
         </New>
        </Arg>
    </New>

</Configure>

Thanks a bunch for your help....

Re: Moving DataBase HSQLDB to MySQL

Posted: Mon Oct 08, 2012 7:41 am
by phillipuniverse
Ensure that in site and admin development.properties the Hibernate dialect is set to org.hibernate.dialect.MySQL5InnoDBDialect. The system_sequences table is an HSQL thing, so one of your Hibernate dialects is probably off.

Re: Moving DataBase HSQLDB to MySQL

Posted: Mon Mar 04, 2013 6:49 am
by sam
Hi All,
I am facing same problem
log
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'system_sequences' in information_schema

Please suggest me, how rectify this problem.

Regards,
Sam

Re: Moving DataBase HSQLDB to MySQL

Posted: Thu Mar 07, 2013 11:14 am
by bc3amor
Good Morning Guys,I need your help with a problem Im Having now about migrating to MySQL database.

I did all what the tutorial said about switching to MySQL db -> http://docs.broadleafcommerce.org/curre ... orial.html

I did this:

1) At "Maven Parents" Folder -> "DemoSite" I changed the pom.xml

---Added these lines

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.21</version>
<type>jar</type>
<scope>compile</scope>
</dependency>

---commented these lines

<!-- <dependency>
<groupId>org.hsqldb</groupId>
<artifactId>hsqldb</artifactId>
<version>2.2.4</version>
<type>jar</type>
<scope>compile</scope>
</dependency> -->

2) At "My BroadLeaf Site" admin and site projects, in pom.xml file

--- Added those lines

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>

--- Commented these ones

<!-- <dependency>
<groupId>org.hsqldb</groupId>
<artifactId>hsqldb</artifactId>
</dependency> -->

3) Did all what tutorial said about -> Change the JNDI resource in jetty-env.xml to match your MySQL installation. -> Replacing the existing properties with these ones

<New id="webDS" class="org.eclipse.jetty.plus.jndi.Resource">
<Arg>jdbc/web</Arg>
<Arg>
<New class="org.apache.commons.dbcp.BasicDataSource">
<Set name="driverClassName">com.mysql.jdbc.Driver</Set>
<Set name="url">jdbc:mysql://localhost:3306/ecommerce_db</Set>
<Set name="username">root</Set>
<Set name="password">1234</Set>
</New>
</Arg>
</New>

<New id="webSecureDS" class="org.eclipse.jetty.plus.jndi.Resource">
<Arg>jdbc/secure</Arg>
<Arg>
<New class="org.apache.commons.dbcp.BasicDataSource">
<Set name="driverClassName">com.mysql.jdbc.Driver</Set>
<Set name="url">jdbc:mysql://localhost:3306/ecommerce_db</Set>
<Set name="username">root</Set>
<Set name="password">1234</Set>
</New>
</Arg>
</New>

<New id="webStorageDS" class="org.eclipse.jetty.plus.jndi.Resource">
<Arg>jdbc/storage</Arg>
<Arg>
<New class="org.apache.commons.dbcp.BasicDataSource">
<Set name="driverClassName">com.mysql.jdbc.Driver</Set>
<Set name="url">jdbc:mysql://localhost:3306/ecommerce_db</Set>
<Set name="username">root</Set>
<Set name="password">1234</Set>
</New>
</Arg>
</New>

4) In common-shared.properties file, I commented the current HSQL lines and added the ones the tutorial said, looking like this

#blCMSStorage.hibernate.dialect=org.hibernate.dialect.HSQLDialect
blCMSStorage.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

#blSecurePU.hibernate.dialect=org.hibernate.dialect.HSQLDialect
blSecurePU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

#blPU.hibernate.dialect=org.hibernate.dialect.HSQLDialect
blPU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

5) And finally I executed the ant process "jetty-demo"

Now then I get some previous errors like this one:

[artifact:mvn] [ERROR] 10:15:47 SchemaExport - Unsuccessful: alter table BLC_STATIC_ASSET add constraint FK9875FB05579FE59D foreign key (SANDBOX_ID) references BLC_SANDBOX
[artifact:mvn] [ERROR] 10:15:47 SchemaExport - Can't create table 'ecommerce_db.#sql-12e0_11' (errno: 150)

Before finally get this

[artifact:mvn] [ WARN] 09:41:51 JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02
[artifact:mvn] [ERROR] 09:41:51 JDBCExceptionReporter - Table 'ecommerce_db.blc_sku' doesn't exist
[artifact:mvn] [ERROR] 09:41:51 JobRunShell - Job DEFAULT.rebuildIndexJobDetail threw an unhandled Exception:
[artifact:mvn] org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'rebuildIndex' on target class [class $Proxy126] failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
[artifact:mvn] at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:320)
[artifact:mvn] at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
[artifact:mvn] at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
[artifact:mvn] at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
[artifact:mvn] Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
[artifact:mvn] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1389)
[artifact:mvn] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1317)
[artifact:mvn] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255)
[artifact:mvn] at org.hibernate.ejb.criteria.CriteriaQueryCompiler$3.getResultList(CriteriaQueryCompiler.java:253)
[artifact:mvn] at org.broadleafcommerce.core.catalog.dao.ProductDaoImpl.readAllActiveProducts(ProductDaoImpl.java:449)
[artifact:mvn] at org.broadleafcommerce.core.search.service.solr.SolrSearchServiceImpl.rebuildIndex(SolrSearchServiceImpl.java:119)
[artifact:mvn] at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:597)
[artifact:mvn] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
[artifact:mvn] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
[artifact:mvn] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
[artifact:mvn] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
[artifact:mvn] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[artifact:mvn] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
[artifact:mvn] at $Proxy126.rebuildIndex(Unknown Source)
[artifact:mvn] at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:597)
[artifact:mvn] at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
[artifact:mvn] at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
[artifact:mvn] ... 3 more
[artifact:mvn] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
[artifact:mvn] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
[artifact:mvn] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[artifact:mvn] at org.hibernate.loader.Loader.doList(Loader.java:2545)
[artifact:mvn] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
[artifact:mvn] at org.hibernate.loader.Loader.list(Loader.java:2271)
[artifact:mvn] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
[artifact:mvn] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
[artifact:mvn] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
[artifact:mvn] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
[artifact:mvn] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
[artifact:mvn] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)
[artifact:mvn] ... 21 more
[artifact:mvn] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ecommerce_db.blc_sku' doesn't exist
[artifact:mvn] at sun.reflect.GeneratedConstructorAccessor77.newInstance(Unknown Source)
[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:1053)
[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)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
[artifact:mvn] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
[artifact:mvn] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
[artifact:mvn] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
[artifact:mvn] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
[artifact:mvn] at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
[artifact:mvn] at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
[artifact:mvn] at org.hibernate.loader.Loader.doQuery(Loader.java:802)
[artifact:mvn] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
[artifact:mvn] at org.hibernate.loader.Loader.doList(Loader.java:2542)
[artifact:mvn] ... 29 more

----------------

I notice checking at the database I created, 147 tables has been created but with no data inside, also that Table 'ecommerce_db.blc_sku' has not been created.

I need your help guys, please, to tell me if Im doing something wrong or missed a step or why am I getting those errors trying to start the demo with my own MySQL DB.

Thanks in advance, Greetings.

Re: Moving DataBase HSQLDB to MySQL

Posted: Fri Mar 29, 2013 6:09 pm
by prakhar
Override the dialects in development.properties and local.properties, somehow in admin module the dialect is still hsql.

Cheers!!
Prakhar

Re: Moving DataBase HSQLDB to MySQL

Posted: Sat May 04, 2013 9:55 am
by altiplanogao
prakhar wrote:Override the dialects in development.properties and local.properties, somehow in admin module the dialect is still hsql.

Cheers!!
Prakhar


try this for persistence.xml,

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
             version="2.0">
             
    <persistence-unit name="blPU" transaction-type="RESOURCE_LOCAL">
        <non-jta-data-source>jdbc/web</non-jta-data-source>
        <exclude-unlisted-classes/>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
            <property name="hibernate.connection.useUnicode" value="true"></property>
            <property name="hibernate.connection.characterEncoding" value="UTF-8"></property>
        </properties>
    </persistence-unit>
   
    <persistence-unit name="blSecurePU" transaction-type="RESOURCE_LOCAL">
        <non-jta-data-source>jdbc/webSecure</non-jta-data-source>
        <exclude-unlisted-classes/>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
            <property name="hibernate.connection.useUnicode" value="true"></property>
            <property name="hibernate.connection.characterEncoding" value="UTF-8"></property>
        </properties>
    </persistence-unit>

    <persistence-unit name="blCMSStorage" transaction-type="RESOURCE_LOCAL">
        <non-jta-data-source>jdbc/cmsStorage</non-jta-data-source>
        <exclude-unlisted-classes/>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
            <property name="hibernate.connection.useUnicode" value="true"></property>
            <property name="hibernate.connection.characterEncoding" value="UTF-8"></property>
        </properties>
    </persistence-unit>
</persistence>

Re: Moving DataBase HSQLDB to MySQL

Posted: Thu Jul 04, 2013 7:36 pm
by aurizar
I am sure everybody got it working by now, but just to help out the new guys like me.

1) After making the changes indicated in the get started guide rebuild the Demo Site project.
mvn clean install
2) Then run the site jetty-demo ant-task. You will see some unsuccessful alter table drop foreign key messages but the site will still work.
3) After the first run, update the development.properties so the tables are not recreated again on every run.
#blPU.hibernate.hbm2ddl.auto=create-drop
blPU.hibernate.hbm2ddl.auto=update

Re: Moving DataBase HSQLDB to MySQL

Posted: Sun Nov 24, 2013 4:37 pm
by panopset
I had this same problem and here's what I had to do to solve it (which may or may not overlap what was mentioned here):

cd /etc/tomcat7
sudo vim context.xml

Add:

Code: Select all

 
  <Resource name="jdbc/web" auth="Container" type="javax.sql.DataSource"
               maxActive="20" maxIdle="5" maxWait="10000"
               username="*" password="*" driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://localhost:3306/zonkweb"/>
  <Resource name="jdbc/storage" auth="Container" type="javax.sql.DataSource"
               maxActive="20" maxIdle="5" maxWait="10000"
               username="*" password="*" driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://localhost:3306/zonkst"/>
  <Resource name="jdbc/secure" auth="Container" type="javax.sql.DataSource"
               maxActive="20" maxIdle="5" maxWait="10000"
               username="*" password="*" driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://localhost:3306/zonksec"/>

Right before:

Code: Select all

</Context>


Replace the username and password of course, and the zonkweb,zonkst, and zonksec MySql database name for your store. You have to create them of course. Not sure yet what the optimum number of connections should be, just found out the hard way they have to total less than what is available in MySql. Use the mysql command

Code: Select all

show processlist;
to see all the connections the above configuration will make.

Reference: http://stackoverflow.com/questions/1620 ... n-database

mysqltuner is also useful.

Reference: http://www.ubuntugeek.com/mysqltuner-ch ... mance.html


Code: Select all

mysql --username <user>
create table zonkweb;
create table zonkst;
create table zonksec;


Reference: http://tomcat.apache.org/tomcat-7.0-doc ... CP_Example.

The resource names are "jdbc/web", "jdbc/storage", and "jdbc/secure", you need all 3.

Unrelated to this post but important, make sure you give Tomcat enough memory:

http://stackoverflow.com/questions/16998378/broad-leaf-commerce-war-deploy-on-tomcat/17126885#17126885
http://stackoverflow.com/questions/6398053/cant-change-tomcat-7-heap-size/10950387#10950387

Once you deploy your war:

Code: Select all

sudo service tomcat7 stop
sudo rm /var/log/tomcat7/catalina.out
sudo service tomcat7 start


Verify no errors in catalina.out.

More details: http://forum.broadleafcommerce.org/viewtopic.php?f=20&t=2157

Re: Moving DataBase HSQLDB to MySQL

Posted: Sat Feb 15, 2014 7:55 pm
by rcampion
Hello,

I attempted to use MySQL for DemoSite-3.0.8-GA-eclipse-workspace.zip

See notes and progress at ...
viewtopic.php?f=15&t=2011&p=6768#p6768

It is my belief that the demo is broken for MySQL until a Hibernate bug is addressed / resolved.

Some tables do not and will not get created in MySQL due to the Hibernate @Lob annotation handling.

Perhaps I am mistaken, if so, please show me your MySQL DDL in your running 3.0.8 DemoSite.

I am particularly interested in the tables that are supposed to handle CLOB(s).

Were any of the following tables created ....

BLC_SC_FLD
BLC_SKU
BLC_SKU_FEE
BLC_PAGE_FLD
BLC_TRANSLATION
BLC_SC_ITEM_CRITERIA
BLC_CATEGORY
BLC_PAGE_ITEM_CRITERIA
BLC_FULFILLMENT_OPTION
BLC_OFFER
BLC_OFFER_ITEM_CRITERIA
BLC_PAGE_RULE
BLC_SC_RULE
BLC_FULFILLMENT_OPTION
BLC_SC_FLD

Since these tables were missing in my case, I created the MySQL database "the old-fashioned way" i.e. via a CreateDatabaseScript.sql and manually populated the data using the same data load scripts that are specified in one of the properties files.

I am using TEXT as the datatype for the fields that are annotated with @LOB in the corresponding Java Entities.

BLC_SC_FLD => StructuredContentFieldImpl
BLC_SKU => SkuImpl
BLC_SKU_FEE => SkuFeeImpl
BLC_PAGE_FLD => PageFieldImpl
BLC_TRANSLATION => TranslationImpl
BLC_SC_ITEM_CRITERIA => StructuredContentItemCriteriaImpl
BLC_CATEGORY => CategoryImpl
BLC_PAGE_ITEM_CRITERIA => PageItemCriteriaImpl
BLC_FULFILLMENT_OPTION => FulfillmentOptionImpl
BLC_OFFER => OfferImpl
BLC_OFFER_ITEM_CRITERIA => OfferItemCriteriaImpl
BLC_PAGE_RULE => PageRuleImpl
BLC_SC_RULE => StructuredContentRuleImpl
BLC_FULFILLMENT_OPTION => FulfillmentOptionImp
BLC_SC_FLD => StructuredContentFieldImpl

With the database created I performed the data population.

config/bc/sql/load_admin_permissions.sql ....... success.
config/bc/sql/load_admin_roles.sql .................. success.
config/bc/sql/load_admin_menu.sql.................. success.
sql/load_admin_users.sql................................ success.
sql/load_code_tables.sql................................. success.
sql/load_table_sequences.sql.......................... success.
sql/load_content_structure.sql......................... success.
sql/load_catalog_data.sql................................ failure. Syntax errors.
sql/load_catalog_pricesplit_data.sql ................ does not exist or could not be found.
sql/load_content_data.sql................................ success.
sql/load_content_structure_i18n.sql.................. success.
sql/load_content_data_i18n.sql......................... success.
sql/load_catalog_i18n_data_FR.sql................... success.
sql/load_catalog_i18n_data_ES.sql....................success.

There are some obvious syntactical errors contained within the load_catalog_data.sql script.

Even with the erroneous data, the admin site will run and I was able to create a new product via the admin UI.

I verified that the newly created product was persisted in the MySQL database.

However, the demo site itself would not render most pages except for the http://localhost:8080/cart page.

Perhaps if the load_catalog_data.sql file was valid and a load_catalog_pricesplit_data.sql was provided then who knows, the demo sight might render all pages.

-Richard

Re: Moving DataBase HSQLDB to MySQL

Posted: Sun Feb 16, 2014 12:57 am
by rcampion
Downloaded 3.1.0 ... DemoSite-3.1.0-GA-eclipse-workspace.zip

1.) Followed the Getting Started Guide and tested HSQLDB ... Good.

2.) Followed the Using MySQL tutorial .... Good.

No Problems!

Same number of tables in both databases.

@Lob string data is being stored as LONGTEXT in MySQL.

Congratulations on your new release!

Thank you.