ksql中使用数据库函数出错

stephenewong

select ER_GCRL.*,(SQL.DATEPART(weekday, ER_GCRL.fRLRQ_RL)) as weekp
    from ER_GCRL ER_GCRL LIMIT 0, 50

错误提示:找不到weekday对应的符号

stephenewong

jishuang 发表于 2013-10-15 14:40
http://www.w3school.com.cn/sql/func_datepart.asp
可以看看DATEPART() 的语法

请看12楼贴回复,我参考缩写datepart,问题依旧

jishuang

把生成的sql语句到数据库中执行一下看看

输出sql参考http://bbs.justep.com/forum.php? ... 4&pid=165004035

stephenewong

jishuang 发表于 2013-10-15 10:30
把生成的sql语句到数据库中执行一下看看

输出sql参考http://bbs.justep.com/forum.php?mod=redirect&goto= ...

内容太多,不给贴,我只选了一部分给你看下:
2013-10-15 10:43:37          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>]
2013-10-15 10:43:37          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>]
2013-10-15 10:43:37          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>]
2013-10-15 10:43:37          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>]
2013-10-15 10:43:37             |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>]
2013-10-15 10:43:37             |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>]
2013-10-15 10:43:37             |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZRRQ_RL, binds=[]>]>]
2013-10-15 10:43:37             |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZRRQ_RL, binds=[]>]>]
2013-10-15 10:43:37          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZRRQ_RL AS fGZRRQ_RL, binds=[]>]>]
2013-10-15 10:43:37          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZRRQ_RL AS fGZRRQ_RL, binds=[]>]>]
2013-10-15 10:43:37          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZRRQ_RL AS fGZRRQ_RL, binds=[]>]>]
2013-10-15 10:43:37          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZRRQ_RL AS fGZRRQ_RL, binds=[]>]>]
2013-10-15 10:43:37             |-->开始 LocalSqlFunctionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZRRQ_RL AS fGZRRQ_RL, binds=[]>]>]
2013-10-15 10:43:37             |-->开始 LocalSqlFunctionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZRRQ_RL AS fGZRRQ_RL, binds=[]>]>]
2013-10-15 10:43:37                |-->开始 IdentiferNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZRRQ_RL AS fGZRRQ_RL, binds=[]>]>]
2013-10-15 10:43:37                |-->开始 IdentiferNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FXL_RL AS fXL_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGCID_RL AS fGCID_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FRLRQ_RL AS fRLRQ_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZR_RL AS fGZR_RL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=ER_GCRL.FGZRRQ_RL AS fGZRRQ_RL, binds=[]>]>]
2013-10-15 10:43:37 invokeActions error！

stephenewong

继续贴出后面部分:
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.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.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        ... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT ER_GCRL.*,(SQL.DATEPART(weekday, ER_GCRL.fRLRQ_RL)) as weekp  FROM ER_GCRL ER_GCRL LIMIT 0, 31时出错！
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:15)
        ... 26 more
Caused by: com.justep.model.exception.ModelException: 找不到weekday对应的符号！
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.IdentiferNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.LocalSqlFunctionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectColumnNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectListNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
        ... 31 more

daniel007

你上面3楼贴的那贴几乎就没有用处。

stephenewong

daniel007 发表于 2013-10-15 10:49
你上面3楼贴的那贴几乎就没有用处。

看不到sql输出到控制台的语句,我想是在解析阶段就出错了.
请看3楼贴的最后一句.

正常情况下,3楼贴的最后一句没有,紧跟着出现KSQL及SQL语句.

jishuang

按照这个修改控制台是会数据sql语句的

stephenewong

jishuang 发表于 2013-10-15 11:14
按照这个修改控制台是会数据sql语句的

晕,已这样做过,要不,请直接远程过来看吧.

daniel007

你把SQl语句到数据库控制台使用后结果是什么？

stephenewong

daniel007 发表于 2013-10-15 11:19
你把SQl语句到数据库控制台使用后结果是什么？

呵呵,是我讲得不明白吗?做了设置后,控制台还没到输出SQL语句时就已经报错了.所以就看不到sql语句的