jeecg_scott 发表于 2013-8-5 20:48:29

3.3.1点击菜单 动态报表配置报错

3.3.1点击菜单 动态报表配置报错

错误日志:Table 'jeecg_v3_team.jform_cgreport_head' doesn't exist
org.hibernate.exception.SQLGrammarException: Table 'jeecg_v3_team.jform_cgreport_head' doesn't exist
      at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
      at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
      at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
      at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
      at $Proxy65.executeUpdate(Unknown Source)
      at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)
      at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868)
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:876)
      at org.jeecgframework.core.common.dao.impl.GenericBaseCommonDao.executeSql(GenericBaseCommonDao.java:829)
      at org.jeecgframework.core.common.service.impl.CommonServiceImpl.executeSql(CommonServiceImpl.java:370)
      at jeecg.cgform.service.impl.build.DataBaseServiceImpl.insertTable(DataBaseServiceImpl.java:55)
      at jeecg.cgform.service.impl.build.DataBaseServiceImpl.insertTableMore(DataBaseServiceImpl.java:157)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy54.insertTableMore(Unknown Source)
      at jeecg.cgform.controller.build.CgFormBuildController.saveOrUpdateMore(CgFormBuildController.java:269)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
      at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
      at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
      at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
      at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
      at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
      at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
      at java.lang.Thread.run(Thread.java:722)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'jeecg_v3_team.jform_cgreport_head' doesn't exist
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440)
      at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2717)
      at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1052)
      at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
      at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2715)
      at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:106)
      at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:237)
      at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
      ... 64 more

解决方法:
同步表单配置的表【jform_cgreport_head】【jform_cgreport_item】



hyz95801 发表于 2013-8-7 20:09:46

问一下,同步表单配置的表【jform_cgreport_head】【jform_cgreport_item】,这两个表我在哪可以找到

jeecg_scott 发表于 2013-8-7 21:16:41

hyz95801 发表于 2013-8-7 20:09 static/image/common/back.gif
问一下,同步表单配置的表【jform_cgreport_head】【jform_cgreport_item】,这两个表我在哪可以找到 ...

表单配置里

jeecg_scott 发表于 2013-8-7 21:16:41

hyz95801 发表于 2013-8-7 20:09 static/image/common/back.gif
问一下,同步表单配置的表【jform_cgreport_head】【jform_cgreport_item】,这两个表我在哪可以找到 ...

表单配置里

tfy824 发表于 2013-8-7 22:04:28

jeecg_scott 发表于 2013-8-7 21:16 static/image/common/back.gif
表单配置里

同步的时候同步失败报空指针 java.lang.NullPointerException
        at jeecg.cgform.service.impl.config.CgFormFieldServiceImpl.judgeTableIsExit(CgFormFieldServiceImpl.java:83),是怎么回事,所有的都是这个

jeecg_scott 发表于 2013-8-7 23:07:58

tfy824 发表于 2013-8-7 22:04 static/image/common/back.gif
同步的时候同步失败报空指针 java.lang.NullPointerException
        at jeecg.cgform.service.impl.config.CgF ...

什么数据库?

tfy824 发表于 2013-8-8 09:53:58

jeecg_scott 发表于 2013-8-7 23:07 static/image/common/back.gif
什么数据库?

数据库是oracle

jeecg_scott 发表于 2013-8-8 17:06:50

tfy824 发表于 2013-8-8 09:53 static/image/common/back.gif
数据库是oracle

我提供一份oracle脚本吧,oracle初始化有些问题
页: [1]
查看完整版本: 3.3.1点击菜单 动态报表配置报错