Broadleaf Commerce Discussion Forums


http://forum.broadleafcommerce.org/

Admin dosen't work

http://forum.broadleafcommerce.org/viewtopic.php?f=13&t=2322

Page 1 of 1

Admin dosen't work

Posted: Mon Dec 09, 2013 10:33 am
by DylanYang
Hi,
I couldn't visit my web page when I visit localhost:8444/admin or localhost:8081.
I use tomcat server.My configration is like

Code: Select all

   
<target name="tomcat-demo">
  <delete dir="war/WEB-INF/lib"/>
  <artifact:mvn mavenHome="${maven.home}" fork="true" jvmargs="-DbroadleafCoreDirectory=${broadleafCoreDirectory} -DbroadleafWorkspaceDirectory=${broadleafWorkspaceDirectory} -XX:MaxPermSize=256M -Xmx512M">
    <arg value="compile"/>
    <arg value="war:exploded"/>
    <arg value="tomcat7:run-war"/>
    <jvmarg value="-javaagent:${spring.instrument.path}" />
  </artifact:mvn>
</target>

It had the error massage showing below:

Code: Select all

HTTP Status 500 - org.hibernate.exception.SQLGrammarException: Table 'broadleaf.BLC_LOCALE' doesn't exist

type Exception report

message org.hibernate.exception.SQLGrammarException: Table 'broadleaf.BLC_LOCALE' doesn't exist

description The server encountered an internal error that prevented it from fulfilling this request.

exception

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Table 'broadleaf.BLC_LOCALE' doesn't exist
   org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
   org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
   org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
   org.broadleafcommerce.common.locale.dao.LocaleDaoImpl.findDefaultLocale(LocaleDaoImpl.java:71)
   org.broadleafcommerce.common.locale.service.LocaleServiceImpl.findDefaultLocale(LocaleServiceImpl.java:46)
   sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.lang.reflect.Method.invoke(Method.java:606)
   org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
   org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
   com.sun.proxy.$Proxy115.findDefaultLocale(Unknown Source)
   org.broadleafcommerce.common.web.BroadleafLocaleResolverImpl.resolveLocale(BroadleafLocaleResolverImpl.java:98)
   org.broadleafcommerce.openadmin.web.filter.BroadleafAdminRequestProcessor.process(BroadleafAdminRequestProcessor.java:74)
   org.broadleafcommerce.openadmin.web.filter.BroadleafAdminRequestFilter.doFilterInternal(BroadleafAdminRequestFilter.java:58)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
   org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:180)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
   org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
   org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:166)
   org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
   org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
   org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
   org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause

org.hibernate.exception.SQLGrammarException: Table 'broadleaf.BLC_LOCALE' doesn't exist
   org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
   org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
   org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
   org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
   org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
   org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
   com.sun.proxy.$Proxy177.executeQuery(Unknown Source)
   org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
   org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
   org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
   org.hibernate.loader.Loader.doQuery(Loader.java:899)
   org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
   org.hibernate.loader.Loader.doList(Loader.java:2516)
   org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
   org.hibernate.loader.Loader.list(Loader.java:2324)
   org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
   org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
   org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
   org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
   org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
   org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
   org.broadleafcommerce.common.locale.dao.LocaleDaoImpl.findDefaultLocale(LocaleDaoImpl.java:71)
   org.broadleafcommerce.common.locale.service.LocaleServiceImpl.findDefaultLocale(LocaleServiceImpl.java:46)
   sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.lang.reflect.Method.invoke(Method.java:606)
   org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
   org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
   com.sun.proxy.$Proxy115.findDefaultLocale(Unknown Source)
   org.broadleafcommerce.common.web.BroadleafLocaleResolverImpl.resolveLocale(BroadleafLocaleResolverImpl.java:98)
   org.broadleafcommerce.openadmin.web.filter.BroadleafAdminRequestProcessor.process(BroadleafAdminRequestProcessor.java:74)
   org.broadleafcommerce.openadmin.web.filter.BroadleafAdminRequestFilter.doFilterInternal(BroadleafAdminRequestFilter.java:58)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
   org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:180)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
   org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
   org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:166)
   org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
   org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
   org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
   org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'broadleaf.BLC_LOCALE' doesn't exist
   sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
   sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   java.lang.reflect.Constructor.newInstance(Constructor.java:526)
   com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
   com.mysql.jdbc.Util.getInstance(Util.java:386)
   com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
   com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
   com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
   com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
   com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
   com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
   com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
   com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2324)
   sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.lang.reflect.Method.invoke(Method.java:606)
   org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
   org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
   com.sun.proxy.$Proxy177.executeQuery(Unknown Source)
   org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
   org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
   org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
   org.hibernate.loader.Loader.doQuery(Loader.java:899)
   org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
   org.hibernate.loader.Loader.doList(Loader.java:2516)
   org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
   org.hibernate.loader.Loader.list(Loader.java:2324)
   org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
   org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
   org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
   org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
   org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
   org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
   org.broadleafcommerce.common.locale.dao.LocaleDaoImpl.findDefaultLocale(LocaleDaoImpl.java:71)
   org.broadleafcommerce.common.locale.service.LocaleServiceImpl.findDefaultLocale(LocaleServiceImpl.java:46)
   sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.lang.reflect.Method.invoke(Method.java:606)
   org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
   org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
   com.sun.proxy.$Proxy115.findDefaultLocale(Unknown Source)
   org.broadleafcommerce.common.web.BroadleafLocaleResolverImpl.resolveLocale(BroadleafLocaleResolverImpl.java:98)
   org.broadleafcommerce.openadmin.web.filter.BroadleafAdminRequestProcessor.process(BroadleafAdminRequestProcessor.java:74)
   org.broadleafcommerce.openadmin.web.filter.BroadleafAdminRequestFilter.doFilterInternal(BroadleafAdminRequestFilter.java:58)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
   org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:180)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
   org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
   org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:166)
   org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
   org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
   org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
   org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs.

Re: Admin dosen't work

Posted: Mon Dec 09, 2013 11:12 am
by Theo Schumacher
Admin does not create the database. Start the Demo-Site first to create the database leaving the site running. Then start the admin
All times are UTC-05:00
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/