就是创建表的语句

建库的sql吗？

是的，我提示这两个表不存在

您好  升级包内应该有对应的数据库升级脚本的  您看下有吗？  因为我这边也是没有单独表的生成sql的

没有升级包里面只有alter table 语句没有create table 语句

您使用的是哪个升级包？我去看下

v7-v8  而且用这个授权包升级后项目都启动不起来

五月 06, 2019 4:41:30 下午 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
五月 06, 2019 4:41:30 下午 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
五月 06, 2019 4:41:30 下午 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: attributeAdded('StockTicker', 'async.Stockticker@4abba51a')
五月 06, 2019 4:41:30 下午 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@7b5dd49d')
五月 06, 2019 4:41:32 下午 org.apache.catalina.core.ApplicationContext log
信息: No Spring WebApplicationInitializer types detected on classpath
五月 06, 2019 4:41:32 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
五月 06, 2019 4:41:36 下午 org.apache.catalina.core.StandardContext listenerStart
严重: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shiroFilter' defined in ServletContext resource [/WEB-INF/config/shiro-context.xml]: Cannot resolve reference to bean 'securityManager' while setting bean property 'securityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'securityManager' defined in ServletContext resource [/WEB-INF/config/shiro-context.xml]: Cannot resolve reference to bean 'authorizingRealm' while setting bean property 'realm'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authorizingRealm' defined in ServletContext resource [/WEB-INF/config/shiro-context.xml]: Cannot resolve reference to bean 'cmsUserMng' while setting bean property 'cmsUserMng'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'cmsUserMng': Unsatisfied dependency expressed through field 'contentMng': Error creating bean with name 'contentMng': Unsatisfied dependency expressed through field 'contentDocMng': Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentMng': Unsatisfied dependency expressed through field 'contentDocMng': Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:240)
at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:697)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:526)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5197)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5720)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1018)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:994)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1296)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:2038)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'securityManager' defined in ServletContext resource [/WEB-INF/config/shiro-context.xml]: Cannot resolve reference to bean 'authorizingRealm' while setting bean property 'realm'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authorizingRealm' defined in ServletContext resource [/WEB-INF/config/shiro-context.xml]: Cannot resolve reference to bean 'cmsUserMng' while setting bean property 'cmsUserMng'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'cmsUserMng': Unsatisfied dependency expressed through field 'contentMng': Error creating bean with name 'contentMng': Unsatisfied dependency expressed through field 'contentDocMng': Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentMng': Unsatisfied dependency expressed through field 'contentDocMng': Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
... 28 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authorizingRealm' defined in ServletContext resource [/WEB-INF/config/shiro-context.xml]: Cannot resolve reference to bean 'cmsUserMng' while setting bean property 'cmsUserMng'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'cmsUserMng': Unsatisfied dependency expressed through field 'contentMng': Error creating bean with name 'contentMng': Unsatisfied dependency expressed through field 'contentDocMng': Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentMng': Unsatisfied dependency expressed through field 'contentDocMng': Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
... 38 more
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'cmsUserMng': Unsatisfied dependency expressed through field 'contentMng': Error creating bean with name 'contentMng': Unsatisfied dependency expressed through field 'contentDocMng': Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentMng': Unsatisfied dependency expressed through field 'contentDocMng': Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:573)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:350)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1214)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
... 48 more
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentMng': Unsatisfied dependency expressed through field 'contentDocMng': Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:573)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:350)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1214)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:187)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1048)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1018)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:570)
... 58 more
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'contentDocMng': Unsatisfied dependency expressed through field 'openOfficeConverter': Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:573)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:350)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1214)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:187)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1048)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1018)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:570)
... 72 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openOfficeConverter' defined in ServletContext resource [/WEB-INF/config/jeecms/jeecms-context.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
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:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:187)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1048)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1018)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:570)
... 86 more
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:449)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:202)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:137)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:102)
at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:186)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4126)
at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:503)
at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:468)
at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213)
at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:275)
at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:151)
at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1106)
at org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:176)
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2587)
at org.hibernate.internal.SessionImpl.get(SessionImpl.java:991)
at com.jeecms.common.hibernate4.HibernateBaseDao.get(HibernateBaseDao.java:53)
at com.jeecms.common.hibernate4.HibernateBaseDao.get(HibernateBaseDao.java:35)
at com.jeecms.core.dao.impl.CmsConfigDaoImpl.findById(CmsConfigDaoImpl.java:13)
at com.jeecms.core.manager.impl.CmsConfigMngImpl.get(CmsConfigMngImpl.java:25)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy25.get(Unknown Source)
at com.jeecms.common.office.OpenOfficeConverter.init(OpenOfficeConverter.java:132)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1706)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1645)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
... 97 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'cmsconfig0_.office_home' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2237)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
... 137 more

五月 06, 2019 4:41:36 下午 org.apache.catalina.core.ApplicationContext log
信息: Closing Spring root WebApplicationContext
五月 06, 2019 4:41:38 下午 org.apache.catalina.core.ApplicationContext log
信息: No Spring WebApplicationInitializer types detected on classpath
五月 06, 2019 4:41:38 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
五月 06, 2019 4:41:44 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring FrameworkServlet 'JeeCmsAdmin'
五月 06, 2019 4:41:45 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring FrameworkServlet 'JeeCmsFront'
五月 06, 2019 4:41:47 下午 org.apache.catalina.core.ApplicationContext log
信息: No Spring WebApplicationInitializer types detected on classpath
五月 06, 2019 4:41:47 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext

启动tomcat 报这些错误信息

回复第77楼