在bizData上选择orderBy报错。

爱我刺鳌

zhaixin 发表于 2014-7-14 15:53
关系名是GDM ，字段名不是GDM 吧？

给看看windowDialog那帖子呗。。。那才是重点。

zhaixin

我把综合案例中的资产改了一下，并测试，没有出错，你哪里到底报什么错
资产的ksql
SELECT DEMO_Asset,DEMO_Asset.version as version,DEMO_Asset.fCode as fCode,DEMO_Asset.fName as fName,DEMO_Asset.fUpdateTime as fUpdateTime,DEMO_Asset.fUseStatus as fUseStatus,DEMO_Asset.fUseStatusName as fUseStatusName,DEMO_Asset.fScode as fScode,DEMO_Asset.fUnitID as fUnitID,DEMO_Asset.fAssetClassID as fAssetClassID,DEMO_Asset.fUnitName as fUnitName,DEMO_Asset.fAssetClassName as fAssetClassName,DEMO_Asset.fSpecType as fSpecType,DEMO_Asset.fDisUseTime as fDisUseTime,DEMO_Asset.fDescription as fDescription,DEMO_Asset.fSName as fSName,DEMO_Asset.fSequence as fSequence,DEMO_Asset.fCreateOrg as fCreateOrg,DEMO_Asset.fCreatePerID as fCreatePerID,DEMO_Asset.fCreatePerName as fCreatePerName,DEMO_Asset.fCreateTime as fCreateTime,DEMO_Asset.fCreateDeptID as fCreateDeptID,DEMO_Asset.fCreateDeptName as fCreateDeptName,DEMO_Asset.fUpdatePerName as fUpdatePerName,DEMO_Asset.fUpdateDeptID as fUpdateDeptID,DEMO_Asset.fUpdateDeptName as fUpdateDeptName,DEMO_Asset.fUpdatePerID as fUpdatePerID,DEMO_Asset.fCreateURL as fCreateURL,DEMO_Asset.fAttachment as fAttachment  FROM DEMO_Asset DEMO_Asset WHERE ((DEMO_Asset.fAssetClassID='E5037DDA-15D7-4C0D-9524-D1FE2EB26730')) ORDER BY fCode ASC LIMIT 0, 20

爱我刺鳌

zhaixin 发表于 2014-7-15 08:57
我把综合案例中的资产改了一下，并测试，没有出错，你哪里到底报什么错
资产的ksql
SELECT DEMO_Asset,DEMO ...

用的oracle数据库？我把报错代码放在oracle数据库里面报错，上网查说是别名的问题。过会我修改一下，然后把错误代码发一下。

爱我刺鳌

zhaixin 发表于 2014-7-15 08:57
我把综合案例中的资产改了一下，并测试，没有出错，你哪里到底报什么错
资产的ksql
SELECT DEMO_Asset,DEMO ...

       
Uncaught object详细
JUSTEP150210, 执行KSQL出错, KSQL: SELECT G_GDXC.* FROM G_GDXC G_GDXC WHERE ((G_GDXC.PM LIKE '%检修%' OR G_GDXC.PM LIKE '%报废%')) ORDER BY GDM ASC LIMIT 0, -1,刷新数据失败

编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT G_GDXC.* FROM G_GDXC G_GDXC WHERE ((G_GDXC.PM LIKE '%检修%' OR G_GDXC.PM LIKE '%报废%')) ORDER BY GDM ASC LIMIT 0, -1
编码: JUSTEP150039; 提示: 执行sql: SELECT G_GDXC.GDM AS GDM, G_GDXC.SWH AS SWH, G_GDXC.CZ AS CZ, G_GDXC.YZ AS YZ, G_GDXC.CH AS CH, G_GDXC.ZIZ AS ZIZ, G_GDXC.HC AS HC, G_GDXC.ZAZ AS ZAZ, G_GDXC.DZM AS DZM, G_GDXC.PM AS PM, G_GDXC.SHR AS SHR, G_GDXC.FZM AS FZM, G_GDXC.PB AS PB, G_GDXC.DDCC AS DDCC, G_GDXC.DDRQ AS DDRQ, G_GDXC.DDSJ AS DDSJ, G_GDXC.YFBZ AS YFBZ, G_GDXC.GDM, G_GDXC.SWH FROM G_GDXC G_GDXC WHERE (G_GDXC.PM LIKE ?) OR (G_GDXC.PM LIKE ?) ORDER BY GDM ASC, binds: [%检修%, %报废%]出错
ORA-00960: ambiguous column naming in select list

java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
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 G_GDXC.* FROM G_GDXC G_GDXC WHERE ((G_GDXC.PM LIKE '%检修%' OR G_GDXC.PM LIKE '%报废%')) ORDER BY GDM ASC LIMIT 0, -1
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)
... 25 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT G_GDXC.GDM AS GDM, G_GDXC.SWH AS SWH, G_GDXC.CZ AS CZ, G_GDXC.YZ AS YZ, G_GDXC.CH AS CH, G_GDXC.ZIZ AS ZIZ, G_GDXC.HC AS HC, G_GDXC.ZAZ AS ZAZ, G_GDXC.DZM AS DZM, G_GDXC.PM AS PM, G_GDXC.SHR AS SHR, G_GDXC.FZM AS FZM, G_GDXC.PB AS PB, G_GDXC.DDCC AS DDCC, G_GDXC.DDRQ AS DDRQ, G_GDXC.DDSJ AS DDSJ, G_GDXC.YFBZ AS YFBZ, G_GDXC.GDM, G_GDXC.SWH FROM G_GDXC G_GDXC WHERE (G_GDXC.PM LIKE ?) OR (G_GDXC.PM LIKE ?) ORDER BY GDM ASC, binds: [%检修%, %报废%]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 30 more
Caused by: java.sql.SQLException: ORA-00960: ambiguous column naming in select list

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 31 more

爱我刺鳌

zhaixin 发表于 2014-7-15 08:57
我把综合案例中的资产改了一下，并测试，没有出错，你哪里到底报什么错
资产的ksql
SELECT DEMO_Asset,DEMO ...

url:/UI/system/service/common/bizAction.j
param:{"process":"/production/trainSubsystem/tjCx/xchchl_shaohf/process/xchchl_rzhzh/xchchl_rzhzhProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"1000000768","executeContext":"","action":"queryG_GDXCAction","parameters":{"variables":{},"filter":"(G_GDXC.PM LIKE '%检修%' OR G_GDXC.PM LIKE '%报废%')","offset":0,"limit":-1,"columns":"GDM,SWH,CZ,YZ,CH,ZIZ,HC,ZAZ,DZM,PM,SHR,FZM,PB,DDCC,DDRQ,DDSJ,YFBZ,G_GDXC","orderBy":"GDM ASC"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"G_GDXC","sequence":"CH,GDM,SWH,PM,CZ,YZ,ZIZ,HC,ZAZ,DZM,SHR,FZM,PB,DDCC,DDRQ,DDSJ,YFBZ"}}}Error: {"message":"执行KSQL出错, KSQL: SELECT G_GDXC.* FROM G_GDXC G_GDXC WHERE ((G_GDXC.PM LIKE '%检修%' OR G_GDXC.PM LIKE '%报废%')) ORDER BY GDM ASC LIMIT 0, -1,刷新数据失败！ ","reason":"","code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\r\n\tat java.lang.reflect.Method.invoke(Method.java:592)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:595)\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT G_GDXC.* FROM G_GDXC G_GDXC WHERE ((G_GDXC.PM LIKE '%检修%' OR G_GDXC.PM LIKE '%报废%')) ORDER BY GDM ASC LIMIT 0, -1\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.BizData.query(Unknown Source)\r\n\tat BizProcedure.query(BizProcedure.java:12)\r\n\t... 25 more\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT G_GDXC.GDM AS GDM, G_GDXC.SWH AS SWH, G_GDXC.CZ AS CZ, G_GDXC.YZ AS YZ, G_GDXC.CH AS CH, G_GDXC.ZIZ AS ZIZ, G_GDXC.HC AS HC, G_GDXC.ZAZ AS ZAZ, G_GDXC.DZM AS DZM, G_GDXC.PM AS PM, G_GDXC.SHR AS SHR, G_GDXC.FZM AS FZM, G_GDXC.PB AS PB, G_GDXC.DDCC AS DDCC, G_GDXC.DDRQ AS DDRQ, G_GDXC.DDSJ AS DDSJ, G_GDXC.YFBZ AS YFBZ, G_GDXC.GDM, G_GDXC.SWH FROM G_GDXC G_GDXC WHERE (G_GDXC.PM LIKE ?) OR (G_GDXC.PM LIKE ?) ORDER BY GDM ASC, binds: [%检修%, %报废%]出错\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)\r\n\t... 30 more\r\nCaused by: java.sql.SQLException: ORA-00960: ambiguous column naming in select list\n\r\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)\r\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)\r\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)\r\n\tat oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)\r\n\tat oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)\r\n\tat oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)\r\n\tat oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)\r\n\tat oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)\r\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\r\n\t... 31 more\r\n","messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT G_GDXC.* FROM G_GDXC G_GDXC WHERE ((G_GDXC.PM LIKE '%检修%' OR G_GDXC.PM LIKE '%报废%')) ORDER BY GDM ASC LIMIT 0, -1","编码: JUSTEP150039; 提示: 执行sql: SELECT G_GDXC.GDM AS GDM, G_GDXC.SWH AS SWH, G_GDXC.CZ AS CZ, G_GDXC.YZ AS YZ, G_GDXC.CH AS CH, G_GDXC.ZIZ AS ZIZ, G_GDXC.HC AS HC, G_GDXC.ZAZ AS ZAZ, G_GDXC.DZM AS DZM, G_GDXC.PM AS PM, G_GDXC.SHR AS SHR, G_GDXC.FZM AS FZM, G_GDXC.PB AS PB, G_GDXC.DDCC AS DDCC, G_GDXC.DDRQ AS DDRQ, G_GDXC.DDSJ AS DDSJ, G_GDXC.YFBZ AS YFBZ, G_GDXC.GDM, G_GDXC.SWH FROM G_GDXC G_GDXC WHERE (G_GDXC.PM LIKE ?) OR (G_GDXC.PM LIKE ?) ORDER BY GDM ASC, binds: [%检修%, %报废%]出错","ORA-00960: ambiguous column naming in select list\n"],"url":"/UI/system/service/common/bizAction.j","param":"{\"process\":\"/production/trainSubsystem/tjCx/xchchl_shaohf/process/xchchl_rzhzh/xchchl_rzhzhProcess\",\"activity\":\"mainActivity\",\"actionFlag\":\"__action_0__\",\"executor\":\"1000000768\",\"executeContext\":\"\",\"action\":\"queryG_GDXCAction\",\"parameters\":{\"variables\":{},\"filter\":\"(G_GDXC.PM LIKE '%检修%' OR G_GDXC.PM LIKE '%报废%')\",\"offset\":0,\"limit\":-1,\"columns\":\"GDM,SWH,CZ,YZ,CH,ZIZ,HC,ZAZ,DZM,PM,SHR,FZM,PB,DDCC,DDRQ,DDSJ,YFBZ,G_GDXC\",\"orderBy\":\"GDM ASC\"},\"translateParameter\":{\"dataType\":\"row-list\",\"transformIdcolumn\":true,\"useNamespace\":true,\"cellnameByRelation\":false,\"rowsConfig\":{\"concept\":\"G_GDXC\",\"sequence\":\"CH,GDM,SWH,PM,CZ,YZ,ZIZ,HC,ZAZ,DZM,SHR,FZM,PB,DDCC,DDRQ,DDSJ,YFBZ\"}}}"}
at Object.errorMessage (http://localhost:8080/x5/$v1b64fa0f03534b5a965b04ab1491d206/base/base.js?language=zh_CN:1:75440)
at Object.justep.Request.sendBizRequest2.callback (http://localhost:8080/x5/$v85578f52ec634f678857b930ee7d5141/component/data/data.js?language=zh_CN:1:14219)
at cbf (http://localhost:8080/x5/$v1b64fa0f03534b5a965b04ab1491d206/base/base.js?language=zh_CN:1:87276)
at Object.sendRequest2 (http://localhost:8080/x5/$v1b64fa0f03534b5a965b04ab1491d206/base/base.js?language=zh_CN:1:87520)
at Object.sendBizRequest2 (http://localhost:8080/x5/$v1b64fa0f03534b5a965b04ab1491d206/base/base.js?language=zh_CN:1:35433)
at null._doRefreshData (http://localhost:8080/x5/$v85578f52ec634f678857b930ee7d5141/component/data/data.js?language=zh_CN:1:13595)
at null.doRefreshData (http://localhost:8080/x5/$v85578f52ec634f678857b930ee7d5141/component/data/data.js?language=zh_CN:1:58408)
at null.refreshData (http://localhost:8080/x5/$v85578f52ec634f678857b930ee7d5141/component/data/data.js?language=zh_CN:1:5224)
at null.loadData (http://localhost:8080/x5/$v85578f52ec634f678857b930ee7d5141/component/data/data.js?language=zh_CN:1:27055)
at HTMLSpanElement. (http://localhost:8080/x5/$v85578f52ec634f678857b930ee7d5141/component/data/data.js?language=zh_CN:1:59012)

zhaixin

G_GDXC.GDM, G_GDXC.SWH 这两个关系是定义为主键关系了吗，在sql的select部分出现了两次，所以造成了这个错误

爱我刺鳌

zhaixin 发表于 2014-7-15 11:57
G_GDXC.GDM, G_GDXC.SWH 这两个关系是定义为主键关系了吗，在sql的select部分出现了两次，所以造成了这个错 ...

翟姐说的我没看懂，主键是   GDM:SWH。这和order by 冲突吗？

zhaixin

一个关系设置为主键关系后，select里面就会出现两次，所以oracle说不知道按哪个排序，为了解决这个问题，就必须在关系名前面加上概念别名，默认的order by没有使用概念别名，需要手工添加上

爱我刺鳌

zhaixin 发表于 2014-7-16 09:22
一个关系设置为主键关系后，select里面就会出现两次，所以oracle说不知道按哪个排序，为了解决这个问题，就 ...

刚才X5入门支持  728094812跟我讲过了。懂了。结帖。