自定义queryAction出错

zoltin

自定义queryAction出错，麻烦各位给个提醒，代码如下：
public static Table queryVinvoiceGroup(){
                Table table = null;
                try{
                Connection conn = ModelUtils.getConnection("/EXPORT/export/data");
                Statement exeistStmt = conn.createStatement();
                String sql = "select vinvoice.* from vinvoice vinvoice group by vinvoice.viname";
                ResultSet rs = exeistStmt.executeQuery(sql);
                table = BizUtils.resultSet2Table(rs, (Model)null);
                }catch(Exception e){
                        e.printStackTrace();
                }
               
                return table;
        }

以下是出错信息：
2014-07-21 17:33:33 开始-WINDOW生成中间文件: /UI/EXPORT/export/process/vinvoive/mainActivity.w
2014-07-21 17:33:33 null
javax.servlet.ServletException: java.lang.NullPointerException
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        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.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:595)
Caused by: java.lang.NullPointerException
        at BizData.processData(BizData.java:339)
        at BizData.execute(BizData.java:59)
        at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source)
        at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source)
        at com.justep.ui.util.UIUtils.xbl(Unknown Source)
        at com.justep.ui.WindowCompiler.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler.compile(Unknown Source)
        at com.justep.ui.WindowServer.getWindow(Unknown Source)
        at com.justep.ui.WindowServer.service(Unknown Source)
        ... 14 more
2014-7-21 17:33:33 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.lang.NullPointerException
        at BizData.processData(BizData.java:339)
        at BizData.execute(BizData.java:59)
        at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source)
        at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source)
        at com.justep.ui.util.UIUtils.xbl(Unknown Source)
        at com.justep.ui.WindowCompiler.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler.compile(Unknown Source)
        at com.justep.ui.WindowServer.getWindow(Unknown Source)
        at com.justep.ui.WindowServer.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        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.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:595)

Tomato_2014

先设置为源码路径；
再设置断点，看看是哪句报错？

忘了忘了

同意楼上的说法，先设置源码路径，看看Java代码有没有问题，然后再看看你的js调用问题

zhaixin

这个自定义queryAction的是怎么调用的，这个action没有参数，不能用作bizdata组件的reader属性

zoltin

Tomato_2014 发表于 2014-7-21 18:23
先设置为源码路径；
再设置断点，看看是哪句报错？

你好，方法设置在bizdata的reader上，还没进去就报这个错误了，没头绪，求指点。

zoltin

忘了忘了 发表于 2014-7-22 08:34
同意楼上的说法，先设置源码路径，看看Java代码有没有问题，然后再看看你的js调用问题 ...

你好，方法设置在bizdata的reader上，还没进去就报这个错误了，没头绪，求指点。

zoltin

zhaixin 发表于 2014-7-22 09:46
这个自定义queryAction的是怎么调用的，这个action没有参数，不能用作bizdata组件的reader属性 ...

在bizdata上调用，那这个action应该需要带上什么参数？（我想在ksql上写上分组语句，结果写不上。）

zhaixin

bizdata使用的queryaction是有要求的，必须有bizQueryProcedure里面的全部参数

参考 group by的数据分页显示
http://bbs.justep.com/thread-54836-1-1.html
(出处: 起步软件技术论坛)

zoltin

zhaixin 发表于 2014-7-22 11:02
bizdata使用的queryaction是有要求的，必须有bizQueryProcedure里面的全部参数

参考 group by的数据分页显 ...

KSQL.select（）中是能传入group by 进行分组的啊？

zhaixin

ksql支持group by，概念的标准查询动作不支持group by