ksql 自定义sql报错

teky

该语句在查询分析器执行都正常，report组件却不能运行！
2017-05-24 11:28:56 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/cus_auto/cus_auto/process/report/reportProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="queryReportAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map><item key="qs"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">1</xbiz:simple></item></xbiz:map></parameter></parameters></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        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.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:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select b.name, CONVERT(varchar, a.oper_date, 120 ) as oper_date, a.customer_no       from Q_source_flow a,Qcode_source b      where a.qsc_no = :qs and a.qsc_no = b.flag
--> sql:
--> binds: []
        at com.justep.exception.BusinessException.create(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.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at KSQLProcedure.query(KSQLProcedure.java:17)
        ... 26 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, Q_source_flow a^^,Qcode_source b中未找到需要的元素, 位置105期望是<EOF>
        at com.justep.exception.KSQLException.create(Unknown Source)
        at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
        at com.justep.system.ksql.token.TokenManager.match(Unknown Source)
        at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
        at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
        ... 31 more
[ERROR] 2017-05-24 11:28:56,048 com.justep.report.controller.DataController - 报表数据获取失败
执行KSQL出错, KSQL: select b.name, CONVERT(varchar, a.oper_date, 120 ) as oper_date, a.customer_no       from Q_source_flow a,Qcode_source b      where a.qsc_no = :qs and a.qsc_no = b.flag
--> sql:
--> binds: []
com.justep.report.exception.ReportServerException: 报表数据获取失败
        at com.justep.report.controller.DataController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.InitController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.Servlet.a(Unknown Source)
        at com.justep.report.Servlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.report.exception.ReportServerException: 执行KSQL出错, KSQL: select b.name, CONVERT(varchar, a.oper_date, 120 ) as oper_date, a.customer_no       from Q_source_flow a,Qcode_source b      where a.qsc_no = :qs and a.qsc_no = b.flag
--> sql:
--> binds: []
        at com.justep.report.controller.DataController.a(Unknown Source)
        at com.justep.report.controller.DataController.a(Unknown Source)
        ... 20 more
Caused by: java.lang.Exception
        ... 22 more
2017-05-24 11:31:16 开始-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2017-05-24 11:31:16 结束-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2017-05-24 11:31:16 开始-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2017-05-24 11:31:16 结束-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2017-05-24 11:31:17 开始-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2017-05-24 11:31:17 结束-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2017-05-24 11:31:17 开始-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2017-05-24 11:31:18 结束-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2017-05-24 11:31:19 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2017-05-24 11:31:19 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2017-05-24 11:31:19 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2017-05-24 11:31:19 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2017-05-24 11:31:19 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2017-05-24 11:31:20 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2017-05-24 11:31:20 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2017-05-24 11:31:20 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2017-05-24 11:31:20 开始-WINDOW生成中间文件: /UI2/cus_auto/cus_auto/process/report/mainActivity.w
2017-05-24 11:31:20 结束-WINDOW生成中间文件: /UI2/cus_auto/cus_auto/process/report/mainActivity.w
2017-05-24 11:31:20 开始-中间文件生成缓存文件: /UI2/cus_auto/cus_auto/process/report/mainActivity.w
2017-05-24 11:31:21 结束-中间文件生成缓存文件: /UI2/cus_auto/cus_auto/process/report/mainActivity.w
2017-05-24 11:31:21 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2017-05-24 11:31:21 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2017-05-24 11:31:21 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2017-05-24 11:31:21 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2017-05-24 11:31:24 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/cus_auto/cus_auto/process/report/reportProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="queryReportAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map><item key="qs"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">1</xbiz:simple></item></xbiz:map></parameter></parameters></action>
java.lang.reflect.InvocationTargetException

teky

at sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.justep.system.action.Engine.invokeActions(Native Method)
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.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:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
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:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select b.name, CONVERT(varchar, a.oper_date, 120 ) as oper_date, a.customer_no       from Q_source_flow a,Qcode_source b      where a.qsc_no = :qs and a.qsc_no = b.flag
--> sql:
--> binds: []
at com.justep.exception.BusinessException.create(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.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.KSQL.select(Unknown Source)
at KSQLProcedure.query(KSQLProcedure.java:17)
... 26 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, Q_source_flow a^^,Qcode_source b中未找到需要的元素, 位置105期望是<EOF>
at com.justep.exception.KSQLException.create(Unknown Source)
at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
at com.justep.system.ksql.token.TokenManager.match(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 31 more
[ERROR] 2017-05-24 11:31:24,037 com.justep.report.controller.DataController - 报表数据获取失败
执行KSQL出错, KSQL: select b.name, CONVERT(varchar, a.oper_date, 120 ) as oper_date, a.customer_no       from Q_source_flow a,Qcode_source b      where a.qsc_no = :qs and a.qsc_no = b.flag
--> sql:
--> binds: []
com.justep.report.exception.ReportServerException: 报表数据获取失败
at com.justep.report.controller.DataController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.InitController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.Servlet.a(Unknown Source)
at com.justep.report.Servlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
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:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.report.exception.ReportServerException: 执行KSQL出错, KSQL: select b.name, CONVERT(varchar, a.oper_date, 120 ) as oper_date, a.customer_no       from Q_source_flow a,Qcode_source b      where a.qsc_no = :qs and a.qsc_no = b.flag
--> sql:
--> binds: []
at com.justep.report.controller.DataController.a(Unknown Source)
at com.justep.report.controller.DataController.a(Unknown Source)
... 20 more
Caused by: java.lang.Exception
... 22 more
2017-05-24 11:32:16 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/cus_auto/cus_auto/process/report/reportProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="queryReportAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map><item key="qs"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">1</xbiz:simple></item></xbiz:map></parameter></parameters></action>
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.justep.system.action.Engine.invokeActions(Native Method)
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.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:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)

teky

teky 发表于 2017-5-24 11:37
at sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAcc ...

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:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select b.name, CONVERT(varchar, a.oper_date, 120 ) as oper_date, a.customer_no       from Q_source_flow a,Qcode_source b      where a.qsc_no = :qs and a.qsc_no = b.flag
--> sql:
--> binds: []
at com.justep.exception.BusinessException.create(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.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.KSQL.select(Unknown Source)
at KSQLProcedure.query(KSQLProcedure.java:17)
... 26 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, Q_source_flow a^^,Qcode_source b中未找到需要的元素, 位置105期望是<EOF>
at com.justep.exception.KSQLException.create(Unknown Source)
at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
at com.justep.system.ksql.token.TokenManager.match(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 31 more
[ERROR] 2017-05-24 11:32:16,885 com.justep.report.controller.DataController - 报表数据获取失败
执行KSQL出错, KSQL: select b.name, CONVERT(varchar, a.oper_date, 120 ) as oper_date, a.customer_no       from Q_source_flow a,Qcode_source b      where a.qsc_no = :qs and a.qsc_no = b.flag
--> sql:
--> binds: []
com.justep.report.exception.ReportServerException: 报表数据获取失败
at com.justep.report.controller.DataController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.InitController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.Servlet.a(Unknown Source)
at com.justep.report.Servlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
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:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.report.exception.ReportServerException: 执行KSQL出错, KSQL: select b.name, CONVERT(varchar, a.oper_date, 120 ) as oper_date, a.customer_no       from Q_source_flow a,Qcode_source b      where a.qsc_no = :qs and a.qsc_no = b.flag
--> sql:
--> binds: []
at com.justep.report.controller.DataController.a(Unknown Source)
at com.justep.report.controller.DataController.a(Unknown Source)
... 20 more
Caused by: java.lang.Exception
... 22 more

jishuang

ksql中多表查询可以用关联查询

teky

jishuang 发表于 2017-5-24 13:25
ksql中多表查询可以用关联查询

关联查询按ksql语法可以使用，但是ksql不支持 CONVERT(varchar, a.oper_date, 120 )这个函数吗,
提示KSQL语法错误, varchar找不到对应的符号描述

jishuang

ksql中用SQL.调用是数据库本地函数

teky

jishuang 发表于 2017-5-24 14:12
ksql中用SQL.调用是数据库本地函数

SQL.convert(varchar, a.oper_date, 120)
这样写还是提示错误编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select a.*,b.*,c.*,SQL.convert(varchar, a.oper_date, 120) as operdt from Q_source_flow a  optional  join Qcode_source b on a.qsc_no = b.flag optional  join Customer_set c on a.customer_no = c.cus_no where a.qsc_no = :qs
编码: JUSTEP154054; 提示: KSQL语法错误, varchar找不到对应的符号描述

jishuang

varchar是SQL中的啊
SQL.调用

teky

jishuang 发表于 2017-5-24 17:01
varchar是SQL中的啊
SQL.调用

要写成这种SQL.convert(SQL.varchar, a.oper_date, 120)
所有调用数据库本地的函数及变量都要在前面加SQL.，建议官方AIP把这个描述详细点！
请结贴