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

jeecg_scott

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

错误日志：

1. [org.hibernate.engine.jdbc.spi.SqlExceptionHelper]Table 'jeecg_v3_team.jform_cgreport_head' doesn't exist
   
2. [org.jeecgframework.core.common.exception.MyExceptionHandler]org.hibernate.exception.SQLGrammarException: Table 'jeecg_v3_team.jform_cgreport_head' doesn't exist
   
3.         at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
   
4.         at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
   
5.         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
   
6.         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
   
7.         at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
   
8.         at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
   
9.         at $Proxy65.executeUpdate(Unknown Source)
   
10.         at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)
    
11.         at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)
    
12.         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
    
13.         at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)
    
14.         at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868)
    
15.         at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:876)
    
16.         at org.jeecgframework.core.common.dao.impl.GenericBaseCommonDao.executeSql(GenericBaseCommonDao.java:829)
    
17.         at org.jeecgframework.core.common.service.impl.CommonServiceImpl.executeSql(CommonServiceImpl.java:370)
    
18.         at jeecg.cgform.service.impl.build.DataBaseServiceImpl.insertTable(DataBaseServiceImpl.java:55)
    
19.         at jeecg.cgform.service.impl.build.DataBaseServiceImpl.insertTableMore(DataBaseServiceImpl.java:157)
    
20.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
21.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    
22.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
23.         at java.lang.reflect.Method.invoke(Method.java:601)
    
24.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    
25.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    
26.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    
27.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    
28.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    
29.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    
30.         at $Proxy54.insertTableMore(Unknown Source)
    
31.         at jeecg.cgform.controller.build.CgFormBuildController.saveOrUpdateMore(CgFormBuildController.java:269)
    
32.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
33.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    
34.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
35.         at java.lang.reflect.Method.invoke(Method.java:601)
    
36.         at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
    
37.         at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
    
38.         at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
    
39.         at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
    
40.         at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
    
41.         at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
    
42.         at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
    
43.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
    
44.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    
45.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    
46.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    
47.         at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140)
    
48.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    
49.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    
50.         at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    
51.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    
52.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    
53.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    
54.         at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)
    
55.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    
56.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    
57.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    
58.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
    
59.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
    
60.         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    
61.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    
62.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    
63.         at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
    
64.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    
65.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    
66.         at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
    
67.         at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
    
68.         at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
    
69.         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    
70.         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    
71.         at java.lang.Thread.run(Thread.java:722)
    
72. Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'jeecg_v3_team.jform_cgreport_head' doesn't exist
    
73.         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
    
74.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
    
75.         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
    
76.         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
    
77.         at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
    
78.         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
    
79.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541)
    
80.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455)
    
81.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440)
    
82.         at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2717)
    
83.         at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1052)
    
84.         at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
    
85.         at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2715)
    
86.         at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:106)
    
87.         at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:237)
    
88.         at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
    
89.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
90.         at java.lang.reflect.Method.invoke(Method.java:601)
    
91.         at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
    
92.         ... 64 more
    

复制代码

1. 
   

复制代码

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

hyz95801

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

jeecg_scott

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

表单配置里

jeecg_scott

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

表单配置里

tfy824

jeecg_scott 发表于 2013-8-7 21:16
表单配置里

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

jeecg_scott

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

什么数据库？

tfy824

jeecg_scott 发表于 2013-8-7 23:07
什么数据库？

数据库是oracle

jeecg_scott

tfy824 发表于 2013-8-8 09:53
数据库是oracle

我提供一份oracle脚本吧，oracle初始化有些问题