对自定义主键的概念order by 主键报错

ly201026

概念的主键是自定义的，如：主键A，在data数据源中设置属性order by为A 后，查询报错，控制台信息如下：

1. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
   
2.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
   
3.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
   
4.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
   
5.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
   
6.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
   
7.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
   
8.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   
9.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
   
10.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
11.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
12.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
13.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
14.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
15.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
16.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    
17.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
18.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    
19.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    
20.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    
21.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
22.         at java.lang.Thread.run(Thread.java:619)
    
23. Caused by: java.lang.reflect.InvocationTargetException
    
24.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
25.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    
26.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    
27.         at java.lang.reflect.Method.invoke(Method.java:597)
    
28.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
29.         ... 21 more
    
30. Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT TC_DriverAllSarlary.*  FROM TC_DriverAllSarlary TC_DriverAllSarlary ORDER BY DriverCode ASC LIMIT 0, 20时出错！
    
31.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
32.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
33.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
34.         at com.justep.system.data.BizData.query(Unknown Source)
    
35.         at BizProcedure.query(BizProcedure.java:12)
    
36.         ... 26 more
    
37. Caused by: com.justep.model.exception.ModelException: 执行sql：SELECT  TC_DriverAllSarlary.DRIVERCODE AS DriverCode, TC_DriverAllSarlary.DRIVERNAME AS DriverName, TC_DriverAllSarlary.COUNTMONTH AS CountMonth, TC_DriverAllSarlary.CARGROUP AS CarGroup, TC_DriverAllSarlary.WORKDAY AS WorkDay, TC_DriverAllSarlary.BASICWAGESPAYABLE AS BasicWagesPayable, TC_DriverAllSarlary.PERFORMANCEAWARD AS PerformanceAward, TC_DriverAllSarlary.NETPAY AS NetPay, TC_DriverAllSarlary.REMARK AS Remark, TC_DriverAllSarlary.DRIVERCODE, TC_DriverAllSarlary.COUNTMONTH FROM TC_DriverAllSarlary TC_DriverAllSarlary  ORDER BY DriverCode ASC, binds:[]出错！
    
38.         at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
    
39.         ... 31 more
    
40. Caused by: java.sql.SQLException: 列名 'DriverCode' 不明确。
    
41.         at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
    
42.         at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
    
43.         at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
    
44.         at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
    
45.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
    
46.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
    
47.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    
48.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    
49.         ... 32 more

复制代码

lanware_smf

改成概念别名.字段格式的试试呢
ORDER BY 概念别名.DriverCode

忘了忘了

Caused by: java.sql.SQLException: 列名 'DriverCode' 不明确。这个不是提示的很清楚了么

如果是关联查询的两个概念中的关系名是一样的，需要自己select中 as 一个别名，不要让两个关系的别名一样，使用的时候用不一样的别名

ly201026

lanware_smf 发表于 2014-10-20 10:55
改成概念别名.字段格式的试试呢
ORDER BY 概念别名.DriverCode

按照你的方法可以了，就是不知道为什么SQL中查询的字段中为什么会列出两个driverCode字段

jishuang

正确的SQL中查询的字段中会列出两个driverCode字段吗？
ksql中只有一个？

ly201026

jishuang 发表于 2014-10-20 11:47
正确的SQL中查询的字段中会列出两个driverCode字段吗？
ksql中只有一个？

会啊

jishuang

什么会啊？
ksql中只有一个，SQL中就要两个？

ly201026

jishuang 发表于 2014-10-21 13:34
什么会啊？
ksql中只有一个，SQL中就要两个？

是这样的，我这里在data组件的order by属性上选择对自定义的主键DriverCode进行排序，然后用平台的查询组件时候就查询报错，报错的SQL在上面已列出，原因是KSQL中select出的列有两个driverCode然后排序的时候不是用的概念名.DriverCode方式。所以就会报错，现在就是不明白为什么会select出两个driverCode字段

jishuang

你好楼主，这个问题需要我在本地环境进行问题重现，所以会花费较长时间，请你耐心等待，我完成后会第一时间反馈结果，谢谢！