自定义查询关联查询报错。

ldxygold

自定义查询 当图一中2个表单独分开查的时候不会报错，为什么2个表一关联查询就报图2的错误？

jishuang

发控制台完整的错误信息

ldxygold

jishuang 发表于 2016-8-16 13:48
发控制台完整的错误信息

"编码: JUSTEP150039; 提示: 执行sql: select * from tblindexinfo, F_OPER_M_REPORT , binds: []出错","reason":"","code":"","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:606)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: java.lang.RuntimeException: 编码: JUSTEP150039; 提示: 执行sql: select * from tblindexinfo, F_OPER_M_REPORT , binds: []出错\r\n\tat Indexdatabase.queryF_Oper_M_ReportWarn(Indexdatabase.java:39)\r\n\t... 27 more\r\n","messages":["编码: JUSTEP150039; 提示: 执行sql: select * from tblindexinfo, F_OPER_M_REPORT , binds: []出错"],"url":"http://192.168.30.122:8080/BusinessServer/business-action","param":{"contentType":"json","accept":"application/json","process":"/GDH/Indexdatabase/process/indexWaring/indexWaringProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"queryF_Oper_M_ReportWarnAction","parameters":{"orgid":"测试111","waringType":"001","year":"2016","month":"08"},"translateParameter":null}}__justepServerErrorEnd__


单独select * from tblindexinfo或者 select * from F_OPER_M_REPORT  是没有问题的

jishuang

发tomcat控制台完整的错误信息，不是运行时前端的提示信息