ontology中queryAction自定义字段后，报错

xuni2

jishuang 发表于 2014-4-18 15:46
设计器中支持的不太完善，直接到源码中修改正确

在源码中写好了，测试也成功了，但是.w就是报错，详见原帖，麻烦帮忙看下。

wangliang

select LI_KJCGJL.*,case when COALESCE(LI_KJCGJL.fWCDW, 0) = 0 then '未确认' when LI_KJCGJL.fWCDW = '1' then '男' when LI_KJCGJL.fWCDW = '2' then '女' else '其他' end as sex
    from LI_KJCGJL LI_KJCGJL
这样测试没有问题，用的什么数据库看看数据是不是有问题 数据有没值的空白

xuni2

wangliang 发表于 2014-4-21 09:53
select LI_KJCGJL.*,case when COALESCE(LI_KJCGJL.fWCDW, 0) = 0 then '未确认' when LI_KJCGJL.fWCDW = ' ...

你这是在.w打开测试结果的吗，我的是用MYSQL的，数据库测试和ONTOLOGY的测试工具是都可以执行的。就是.w文件上打开就出问题。这个字段在表中不是0就是100，无空值

zhaixin

发一下控制台里面的完整错误信息

xuni2

zhaixin 发表于 2014-4-21 11:22
发一下控制台里面的完整错误信息

2014-04-21 11:24:04 开始-WINDOW生成中间文件: /UI/CLOTHING_DRP_GUOYI/PurchaseManage/process/PurchaseContract/mainActivity.w
2014-04-21 11:24:04 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-4-21 11:24:04 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)

zhaixin

你好楼主，这个问题帮你远程看一下，您可以按照签名中的联系方式联系我（等待远程申请）

zhaixin

发现 WHEN  CL_PurchaseContractHd.yDocStatus = -1
有负号就会报错
你好楼主，您反馈的这个现象通过验证是产品缺陷，我们已提交到产品组（编号：2014042100009），感谢楼主的支持与配合。

xuni2

暂时处理方式：WHEN  CL_PurchaseContractHd.yDocStatus = '-1'，-1加单引号