| 
 | 
 
 
发表于 2018-4-23 22:52:09
|
显示全部楼层
 
 
 
admin 发表于 2018-4-23 21:26   
看看这个文本有没有类似问题 
https://github.com/zhangdaiscott/jeecg-nomaven  
我也发现类似的问题,用3.7.3版本。 
Online在线开发后,用了popup空间 动态报表的字典,获取部门数据depart_name 
生成代码后导出直接报错,说是找不到depart_name表 
 
四月 23, 2018 10:47:20 下午 org.apache.tomcat.util.http.Parameters processParameters 
警告: Parameters: Invalid chunk '' ignored. 
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select DISTINCT branchName,branchCode as TYPECODE , departname,org_code as TYPENAME from depart_name order by branchName,branchCode]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecg.depart_name' doesn't exist 
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) 
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) 
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660) 
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695) 
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722) 
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:772) 
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192) 
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:199) 
        at org.jeecgframework.minidao.aop.MiniDaoHandler.getReturnMinidaoResult(MiniDaoHandler.java:337) 
        at org.jeecgframework.minidao.aop.MiniDaoHandler.invoke(MiniDaoHandler.java:106) 
        at com.sun.proxy.$Proxy47.queryCustomDict(Unknown Source) 
        at org.jeecgframework.easypoi.service.EasypoiDictService.queryDict(EasypoiDictService.java:45) 
        at org.jeecgframework.poi.excel.export.base.ExportBase.getExcelField(ExportBase.java:232) 
        at org.jeecgframework.poi.excel.export.base.ExportBase.createExcelExportEntity(ExportBase.java:66) 
        at org.jeecgframework.poi.excel.export.base.ExportBase.getAllExcelField(ExportBase.java:112) 
        at org.jeecgframework.poi.excel.export.ExcelExportServer.createSheet(ExcelExportServer.java:135) 
        at org.jeecgframework.poi.excel.ExcelExportUtil.exportExcel(ExcelExportUtil.java:62) 
        at org.jeecgframework.poi.excel.view.JeecgSingleExcelView.renderMergedOutputModel(JeecgSingleExcelView.java:59) 
        at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:267) 
        at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1221) 
        at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1005) 
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:952) 
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870) 
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961) 
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852) 
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) 
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:119) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) 
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150) 
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) 
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) 
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) 
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 
        at java.lang.Thread.run(Thread.java:745) 
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecg.depart_name' doesn't exist 
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) 
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526) 
        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:1054) 
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) 
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) 
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) 
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) 
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) 
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) 
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) 
        at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2708) 
        at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465) 
        at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2705) 
        at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:99) 
        at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:211) 
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:703) 
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644) 
        ... 51 more 
[2018-04-23 22:47:20] [ERROR] [org.jeecgframework.easypoi.service.EasypoiDictService:47] org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select DISTINCT branchName,branchCode as TYPECODE , departname,org_code as TYPENAME from depart_name order by branchName,branchCode]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecg.depart_name' doesn't exist 
[2018-04-23 22:47:20] [ERROR] [org.jeecgframework.poi.excel.export.ExcelExportServer:171]  
java.lang.NullPointerException 
        at org.jeecgframework.easypoi.service.EasypoiDictService.queryDict(EasypoiDictService.java:50) 
        at org.jeecgframework.poi.excel.export.base.ExportBase.getExcelField(ExportBase.java:232) 
        at org.jeecgframework.poi.excel.export.base.ExportBase.createExcelExportEntity(ExportBase.java:66) 
        at org.jeecgframework.poi.excel.export.base.ExportBase.getAllExcelField(ExportBase.java:112) 
        at org.jeecgframework.poi.excel.export.ExcelExportServer.createSheet(ExcelExportServer.java:135) 
        at org.jeecgframework.poi.excel.ExcelExportUtil.exportExcel(ExcelExportUtil.java:62) 
        at org.jeecgframework.poi.excel.view.JeecgSingleExcelView.renderMergedOutputModel(JeecgSingleExcelView.java:59) 
        at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:267) 
        at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1221) 
        at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1005) 
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:952) 
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870) 
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961) 
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852) 
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) 
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:119) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) 
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150) 
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) 
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) 
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) 
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 
        at java.lang.Thread.run(Thread.java:745) 
[2018-04-23 22:47:20] [ERROR] [org.jeecgframework.poi.excel.export.ExcelExportServer:172]  
java.lang.NullPointerException 
        at org.jeecgframework.easypoi.service.EasypoiDictService.queryDict(EasypoiDictService.java:50) 
        at org.jeecgframework.poi.excel.export.base.ExportBase.getExcelField(ExportBase.java:232) 
        at org.jeecgframework.poi.excel.export.base.ExportBase.createExcelExportEntity(ExportBase.java:66) 
        at org.jeecgframework.poi.excel.export.base.ExportBase.getAllExcelField(ExportBase.java:112) 
        at org.jeecgframework.poi.excel.export.ExcelExportServer.createSheet(ExcelExportServer.java:135) 
        at org.jeecgframework.poi.excel.ExcelExportUtil.exportExcel(ExcelExportUtil.java:62) 
        at org.jeecgframework.poi.excel.view.JeecgSingleExcelView.renderMergedOutputModel(JeecgSingleExcelView.java:59) 
        at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:267) 
        at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1221) 
        at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1005) 
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:952) 
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870) 
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961) 
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852) 
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) 
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:119) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) 
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150) 
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) 
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) 
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) 
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 
        at java.lang.Thread.run(Thread.java:745) 
四月 23, 2018 10:47:20 下午 org.apache.catalina.core.StandardWrapperValve invoke 
严重: Servlet.service() for servlet springMvc threw exception 
org.jeecgframework.poi.exception.excel.ExcelExportException: Excel导出错误 
        at org.jeecgframework.poi.excel.export.ExcelExportServer.createSheet(ExcelExportServer.java:173) 
        at org.jeecgframework.poi.excel.ExcelExportUtil.exportExcel(ExcelExportUtil.java:62) 
        at org.jeecgframework.poi.excel.view.JeecgSingleExcelView.renderMergedOutputModel(JeecgSingleExcelView.java:59) 
        at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:267) 
        at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1221) 
        at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1005) 
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:952) 
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870) 
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961) 
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852) 
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) 
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:119) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) 
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150) 
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) 
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) 
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) 
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 
        at java.lang.Thread.run(Thread.java:745) |   
 
 
 
 |