Ksql问题，此问题导致界面无法显示

zhuhao0306

LIMIT做sql 语句分页明显有问题吧，应该是x5平台内部分页的问题，分页时没有判断是哪一种数据库

忘了忘了

zhuhao0306 发表于 2014-7-14 15:02
个人感觉不是这个问题，我用的是sqlserver数据库，而sql语句中出现了LIIMIT，这个好像不是sqlserver的语句 ...

起步的使用的是kSQL，KSQL查询的数据会自动和sqlserver进行转换

zhuhao0306

那我为什么用的是sqlserver数据库，而显示的异常信息中sql语句还是带LIMIT这个词语做分页呢？

wangliang

提示里显示了 是KSQL 你看的不是最终sql

zhaixin

到控制台里面看一下这个执行ksql出错的下一个错误是什么，才能看出ksql语句有什么错误

zhuhao0306

2014-07-15 12:00:36 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="true" process="/HR/train/process/myTrain/myTrainProcess" activity="myTrain" action-flag="__action_0__" executor="PSN01" execute-context="" name="queryHR_TR_SignUPAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map/></parameter><parameter name="offset"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">0</xbiz:simple></parameter><parameter name="limit"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">20</xbiz:simple></parameter><parameter name="columns"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[version,fApplyPerID,fApplyPerName,fApplyPerCode,fApplyDeptID,fApplyDeptName,fApplyDeptCode,fApplyDate,fTrainName,fIsCommend,fComPerID,fComPerName,fComPerCode,fComDeptID,fComDeptName,fComDeptCode,fComPositionID,fComPositionName,fComPositionCode,fBizState,fBizStateName,fTrainID,fTrainCode,fCurrentExecutors,fCurrentActivities,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePosID,fCreatePosName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreatePsnFName,fCreateTime,fUpdatePsnID,fUpdatePsnName,fUpdateTime,FAPPLYPOSTCODE,fApplyPostID,fApplyPostName,fComPerFID,HR_TR_SignUP]]></xbiz:simple></parameter><parameter name="orderBy"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[fCreateTime DESC]]></xbiz:simple></parameter></parameters><translate-parameter data-type="row-list" transform-idcolumn="true" use-namespace="true" cellname-by-relation="false"><rows-config concept="HR_TR_SignUP" sequence="recNo,fBizStateName,fCurrentActivities,fCurrentExecutors,fTrainName,fApplyPerName,fComPerName,fCreatePsnName,fCreateTime,space-column,version,fApplyPerID,fApplyPerCode,fApplyDeptID,fApplyDeptName,fApplyDeptCode,fApplyDate,fIsCommend,fComPerID,fComPerCode,fComDeptID,fComDeptName,fComDeptCode,fComPositionID,fComPositionName,fComPositionCode,fBizState,fTrainID,fTrainCode,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePosID,fCreatePosName,fCreatePsnID,fCreatePsnFID,fCreatePsnFName,fUpdatePsnID,fUpdatePsnName,fUpdateTime,FAPPLYPOSTCODE,fApplyPostID,fApplyPostName,fComPerFID"/></translate-parameter></action>
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)
        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: com.justep.exception.BusinessException: ±ძ: JUSTEP150210; ͡ʾ: ִѐKSQL³� KSQL: SELECT HR_TR_SignUP.*  FROM HR_TR_SignUP HR_TR_SignUP ORDER BY fCreateTime DESC LIMIT 0, 20
        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.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 26 more
Caused by: com.justep.exception.BusinessException: ±ძ: JUSTEP150055; ͡ʾ: ՚ģ¿砯HR"Ђ»

zhuhao0306

2014-07-15 12:00:36 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="true" process="/HR/train/process/myTrain/myTrainProcess" activity="myTrain" action-flag="__action_0__" executor="PSN01" execute-context="" name="queryHR_TR_SignUPAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map/></parameter><parameter name="offset"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">0</xbiz:simple></parameter><parameter name="limit"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">20</xbiz:simple></parameter><parameter name="columns"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[version,fApplyPerID,fApplyPerName,fApplyPerCode,fApplyDeptID,fApplyDeptName,fApplyDeptCode,fApplyDate,fTrainName,fIsCommend,fComPerID,fComPerName,fComPerCode,fComDeptID,fComDeptName,fComDeptCode,fComPositionID,fComPositionName,fComPositionCode,fBizState,fBizStateName,fTrainID,fTrainCode,fCurrentExecutors,fCurrentActivities,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePosID,fCreatePosName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreatePsnFName,fCreateTime,fUpdatePsnID,fUpdatePsnName,fUpdateTime,FAPPLYPOSTCODE,fApplyPostID,fApplyPostName,fComPerFID,HR_TR_SignUP]]></xbiz:simple></parameter><parameter name="orderBy"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[fCreateTime DESC]]></xbiz:simple></parameter><parameter name="filter"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[(fApplyPerID='PSN01')]]></xbiz:simple></parameter></parameters><translate-parameter data-type="row-list" transform-idcolumn="true" use-namespace="true" cellname-by-relation="false"><rows-config concept="HR_TR_SignUP" sequence="recNo,fBizStateName,fCurrentActivities,fCurrentExecutors,fTrainName,fApplyPerName,fComPerName,fCreatePsnName,fCreateTime,space-column,version,fApplyPerID,fApplyPerCode,fApplyDeptID,fApplyDeptName,fApplyDeptCode,fApplyDate,fIsCommend,fComPerID,fComPerCode,fComDeptID,fComDeptName,fComDeptCode,fComPositionID,fComPositionName,fComPositionCode,fBizState,fTrainID,fTrainCode,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePosID,fCreatePosName,fCreatePsnID,fCreatePsnFID,fCreatePsnFName,fUpdatePsnID,fUpdatePsnName,fUpdateTime,FAPPLYPOSTCODE,fApplyPostID,fApplyPostName,fComPerFID"/></translate-parameter></action>
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)
        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: com.justep.exception.BusinessException: ±ძ: JUSTEP150210; ͡ʾ: ִѐKSQL³� KSQL: SELECT HR_TR_SignUP.*  FROM HR_TR_SignUP HR_TR_SignUP WHERE ((fApplyPerID='PSN01')) ORDER BY fCreateTime DESC LIMIT 0, 20
        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.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 26 more
Caused by: com.justep.exception.BusinessException: ±ძ: JUSTEP150055; ͡ʾ: ՚ģ¿砯HR"Ђ»

zhaixin

JUSTEP150055的错误是在模块"{0}"下获取数据库连接出错
检查一下数据源的配置吧

zhuhao0306

sqlserver数据库连接这块没有问题，这块在运行之前都在x5中连接运行测试过

zhaixin

远程结果，没有按照HR部署手册配置数据源