|
|
对第2列“使用者类型”排序时，报错。可是在我的sql语句是有“syzlx_name”字段的
2016-08-15 11:20:25 [SQL Time]sql 执行时间：5ms, exec KSQL: SELECT T_pda.*,t_sys_code_syzlx.name as syzlx_name,t_sys_code_syzlx.flag as syzlx_flag,t_sys_code_gzzt.flag as gzzt_flag,t_sys_code_gzzt.name as gzzt_name,t_sys_code_sclx.flag as sclx_flag,t_sys_code_sclx.name as sclx_name,t_disp_group_sc.ddz_mc as sc_ddz_mc FROM T_pda T_pda optional join t_sys_code_syzlx t_sys_code_syzlx on T_pda.syz_lx = t_sys_code_syzlx.code optional join t_sys_code_gzzt t_sys_code_gzzt on T_pda.work_zt = t_sys_code_gzzt.code optional join t_sys_code_sclx t_sys_code_sclx on T_pda.pda_zt = t_sys_code_sclx.code optional join t_disp_group_sc t_disp_group_sc on T_pda.ddz_id = t_disp_group_sc.ddz_id WHERE (t_sys_code_syzlx.flag = 'syzlx_sc' AND t_sys_code_gzzt.flag = 'work_zt' AND t_sys_code_sclx.flag = 'sbzt_sc') ORDER BY syzlx_name ASC LIMIT 0, 20
--> sql:SELECT * FROM (SELECT TOP 100 PERCENT ROW_NUMBER() OVER( ORDER BY syzlx_name ASC) AS JUSTEP_RN__, T_pda.fID AS T_pda, T_pda.DDZ_ID AS ddz_id, t_sys_code_gzzt.FLAG AS gzzt_flag, t_sys_code_gzzt.NAME AS gzzt_name, T_pda.PDA_ID AS pda_id, T_pda.PDA_ZT AS pda_zt, t_disp_group_sc.DDZ_MC AS sc_ddz_mc, t_sys_code_sclx.FLAG AS sclx_flag, t_sys_code_sclx.NAME AS sclx_name, T_pda.SIM AS sim, T_pda.SYZ_LX AS syz_lx, T_pda.SYZ_MC AS syz_mc, t_sys_code_syzlx.FLAG AS syzlx_flag, t_sys_code_syzlx.NAME AS syzlx_name, T_pda.TIMESTAMP AS timestamp, T_pda.USER_ID AS user_id, T_pda.WORK_ZT AS work_zt FROM t_pda T_pda LEFT JOIN t_sys_code t_sys_code_syzlx ON T_pda.SYZ_LX = t_sys_code_syzlx.CODE LEFT JOIN t_sys_code t_sys_code_gzzt ON T_pda.WORK_ZT = t_sys_code_gzzt.CODE LEFT JOIN t_sys_code t_sys_code_sclx ON T_pda.PDA_ZT = t_sys_code_sclx.CODE LEFT JOIN t_disp_group t_disp_group_sc ON T_pda.DDZ_ID = t_disp_group_sc.DDZ_ID WHERE (t_sys_code_syzlx.FLAG = ?) AND (t_sys_code_gzzt.FLAG = ?) AND (t_sys_code_sclx.FLAG = ?) ORDER BY syzlx_name ASC) AS JUSTEP_TABLE__ WHERE JUSTEP_RN__ >= 1 AND JUSTEP_RN__<21
--> binds:[syzlx_sc, work_zt, sbzt_sc]
2016-08-15 11:20:25 [KSQL Time]sql 执行时间：7ms, ksql:SELECT T_pda.*,t_sys_code_syzlx.name as syzlx_name,t_sys_code_syzlx.flag as syzlx_flag,t_sys_code_gzzt.flag as gzzt_flag,t_sys_code_gzzt.name as gzzt_name,t_sys_code_sclx.flag as sclx_flag,t_sys_code_sclx.name as sclx_name,t_disp_group_sc.ddz_mc as sc_ddz_mc FROM T_pda T_pda optional join t_sys_code_syzlx t_sys_code_syzlx on T_pda.syz_lx = t_sys_code_syzlx.code optional join t_sys_code_gzzt t_sys_code_gzzt on T_pda.work_zt = t_sys_code_gzzt.code optional join t_sys_code_sclx t_sys_code_sclx on T_pda.pda_zt = t_sys_code_sclx.code optional join t_disp_group_sc t_disp_group_sc on T_pda.ddz_id = t_disp_group_sc.ddz_id WHERE (t_sys_code_syzlx.flag = 'syzlx_sc' AND t_sys_code_gzzt.flag = 'work_zt' AND t_sys_code_sclx.flag = 'sbzt_sc') ORDER BY syzlx_name ASC LIMIT 0, 20
2016-08-15 11:20:25 excute stream action, params:{"accept":"application/json","action":"queryT_pdaAction","actionFlag":"__action_0__","activity":"pdaActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"T_pda,ddz_id,gzzt_flag,gzzt_name,pda_id,pda_zt,sc_ddz_mc,sclx_flag,sclx_name,sim,syz_lx,syz_mc,syzlx_flag,syzlx_name,timestamp,user_id,work_zt","limit":20,"offset":0,"orderBy":"syzlx_name ASC","variables":{}},"process":"/qx/qx/process/jc_pda/jc_pdaProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"T_pda","sequence":"T_pda,calcCheckBox,ddz_id,gzzt_flag,gzzt_name,pda_id,pda_zt,sc_ddz_mc,sclx_flag,sclx_name,sim,syz_lx,syz_mc,syzlx_flag,syzlx_name,timestamp,user_id,work_zt"},"transformIdcolumn":true,"useNamespace":true}}
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
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 T_pda.*,t_sys_code_syzlx.name as syzlx_name,t_sys_code_syzlx.flag as syzlx_flag,t_sys_code_gzzt.flag as gzzt_flag,t_sys_code_gzzt.name as gzzt_name,t_sys_code_sclx.flag as sclx_flag,t_sys_code_sclx.name as sclx_name,t_disp_group_sc.ddz_mc as sc_ddz_mc FROM T_pda T_pda optional join t_sys_code_syzlx t_sys_code_syzlx on T_pda.syz_lx = t_sys_code_syzlx.code optional join t_sys_code_gzzt t_sys_code_gzzt on T_pda.work_zt = t_sys_code_gzzt.code optional join t_sys_code_sclx t_sys_code_sclx on T_pda.pda_zt = t_sys_code_sclx.code optional join t_disp_group_sc t_disp_group_sc on T_pda.ddz_id = t_disp_group_sc.ddz_id WHERE (t_sys_code_syzlx.flag = 'syzlx_sc' AND t_sys_code_gzzt.flag = 'work_zt' AND t_sys_code_sclx.flag = 'sbzt_sc') ORDER BY syzlx_name ASC LIMIT 0, 20
--> sql: SELECT * FROM (SELECT TOP 100 PERCENT ROW_NUMBER() OVER( ORDER BY syzlx_name ASC) AS JUSTEP_RN__, T_pda.fID AS T_pda, T_pda.DDZ_ID AS ddz_id, t_sys_code_gzzt.FLAG AS gzzt_flag, t_sys_code_gzzt.NAME AS gzzt_name, T_pda.PDA_ID AS pda_id, T_pda.PDA_ZT AS pda_zt, t_disp_group_sc.DDZ_MC AS sc_ddz_mc, t_sys_code_sclx.FLAG AS sclx_flag, t_sys_code_sclx.NAME AS sclx_name, T_pda.SIM AS sim, T_pda.SYZ_LX AS syz_lx, T_pda.SYZ_MC AS syz_mc, t_sys_code_syzlx.FLAG AS syzlx_flag, t_sys_code_syzlx.NAME AS syzlx_name, T_pda.TIMESTAMP AS timestamp, T_pda.USER_ID AS user_id, T_pda.WORK_ZT AS work_zt FROM t_pda T_pda LEFT JOIN t_sys_code t_sys_code_syzlx ON T_pda.SYZ_LX = t_sys_code_syzlx.CODE LEFT JOIN t_sys_code t_sys_code_gzzt ON T_pda.WORK_ZT = t_sys_code_gzzt.CODE LEFT JOIN t_sys_code t_sys_code_sclx ON T_pda.PDA_ZT = t_sys_code_sclx.CODE LEFT JOIN t_disp_group t_disp_group_sc ON T_pda.DDZ_ID = t_disp_group_sc.DDZ_ID WHERE (t_sys_code_syzlx.FLAG = ?) AND (t_sys_code_gzzt.FLAG = ?) AND (t_sys_code_sclx.FLAG = ?) ORDER BY syzlx_name ASC) AS JUSTEP_TABLE__ WHERE JUSTEP_RN__ >= 1 AND JUSTEP_RN__<21
--> binds: [syzlx_sc, work_zt, sbzt_sc]
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:137)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT * FROM (SELECT TOP 100 PERCENT ROW_NUMBER() OVER( ORDER BY syzlx_name ASC) AS JUSTEP_RN__, T_pda.fID AS T_pda, T_pda.DDZ_ID AS ddz_id, t_sys_code_gzzt.FLAG AS gzzt_flag, t_sys_code_gzzt.NAME AS gzzt_name, T_pda.PDA_ID AS pda_id, T_pda.PDA_ZT AS pda_zt, t_disp_group_sc.DDZ_MC AS sc_ddz_mc, t_sys_code_sclx.FLAG AS sclx_flag, t_sys_code_sclx.NAME AS sclx_name, T_pda.SIM AS sim, T_pda.SYZ_LX AS syz_lx, T_pda.SYZ_MC AS syz_mc, t_sys_code_syzlx.FLAG AS syzlx_flag, t_sys_code_syzlx.NAME AS syzlx_name, T_pda.TIMESTAMP AS timestamp, T_pda.USER_ID AS user_id, T_pda.WORK_ZT AS work_zt FROM t_pda T_pda LEFT JOIN t_sys_code t_sys_code_syzlx ON T_pda.SYZ_LX = t_sys_code_syzlx.CODE LEFT JOIN t_sys_code t_sys_code_gzzt ON T_pda.WORK_ZT = t_sys_code_gzzt.CODE LEFT JOIN t_sys_code t_sys_code_sclx ON T_pda.PDA_ZT = t_sys_code_sclx.CODE LEFT JOIN t_disp_group t_disp_group_sc ON T_pda.DDZ_ID = t_disp_group_sc.DDZ_ID WHERE (t_sys_code_syzlx.FLAG = ?) AND (t_sys_code_gzzt.FLAG = ?) AND (t_sys_code_sclx.FLAG = ?) ORDER BY syzlx_name ASC) AS JUSTEP_TABLE__ WHERE JUSTEP_RN__ >= 1 AND JUSTEP_RN__<21, binds: [syzlx_sc, work_zt, sbzt_sc]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 32 more
Caused by: java.sql.SQLException: 列名 'syzlx_name' 无效。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 33 more
|
-
-
|
IP卡
狗仔卡
发表于 2016-8-15 11:21:54
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2016-8-15 11:43:19
楼主