数据查询问题

yyywt · 发表于 2013-10-24 13:30:48

select CR_GRKH.*,SA_OPPerson.sName as sName
from CR_GRKH CR_GRKH
join SA_OPPerson SA_OPPerson on CR_GRKH.cstate = '0' AND CR_GRKH.cmanager = SA_OPPerson.sid

这条语句在PLSQL里面查询没问题，KSQL报错，应该怎么改？

悲催的程序员 · 发表于 2013-10-24 13:42:49

包什么错？在ksql查询中如果是fid或者SID 都是没有的其实只要写成概念名就是代替了fid或者sid

yyywt · 发表于 2013-10-24 13:47:12

2013-10-24 13:46:15 invokeActions error！
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
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: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor124.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)
... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:select CR_GRKH.*,SA_OPPerson.sName as sName    from CR_GRKH CR_GRKH    join SA_OPPerson SA_OPPerson on CR_GRKH.cmanager = SA_OPPerson    where CR_GRKH.cstate = '0'    order by CR_GRKH.cregtime desc LIMIT 0, 50时出错！
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:15)
... 25 more
Caused by: com.justep.model.exception.ModelException: 模型/crm/clientinfo/data下未找到概念SA_OPPerson的Store配置！
at com.justep.util.Utils.check(Unknown Source)
at com.justep.system.ksql.ConceptMapping.getConceptMapping(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.confirmSymTable(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.handleAllRelation(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(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)
... 30 more
2013-10-24 13:46:15 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
<action xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:p="http://www.orbeon.com/oxf/pipeline" xmlns:justep="http://www.justep.com/x5#" xmlns:xslt="http://www.orbeon.com/oxf/processors" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:oxf="http://www.orbeon.com/oxf/processors" xmlns:ns="http://www.justep.com/x5#" xmlns:xbiz="http://www.justep.com/xbiz#" activity="mainActivity" process="/SA/OPM/system/systemProcess" name="queryDataTestAction"><parameters><parameter name="ksql"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">select CR_GRKH.*,SA_OPPerson.sName as sName    from CR_GRKH CR_GRKH    join SA_OPPerson SA_OPPerson on CR_GRKH.cmanager = SA_OPPerson    where CR_GRKH.cstate = '0'    order by CR_GRKH.cregtime desc LIMIT 0, 50</xbiz:simple></parameter><parameter name="dataModel"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">/crm/clientinfo/data</xbiz:simple></parameter></parameters></action>
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
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: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor124.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)
... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:select CR_GRKH.*,SA_OPPerson.sName as sName    from CR_GRKH CR_GRKH    join SA_OPPerson SA_OPPerson on CR_GRKH.cmanager = SA_OPPerson    where CR_GRKH.cstate = '0'    order by CR_GRKH.cregtime desc LIMIT 0, 50时出错！
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:15)
... 25 more
Caused by: com.justep.model.exception.ModelException: 模型/crm/clientinfo/data下未找到概念SA_OPPerson的Store配置！
at com.justep.util.Utils.check(Unknown Source)
at com.justep.system.ksql.ConceptMapping.getConceptMapping(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.confirmSymTable(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.handleAllRelation(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(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)
... 30 more

yyywt · 发表于 2013-10-24 13:55:55

是不是我不能调用SA_OPPerson啊？和我的项目不在一个目录下面，但是我想做这两个表连接需要怎么实现呢？

悲催的程序员 · 发表于 2013-10-24 13:59:47

模型/crm/clientinfo/data下未找到概念SA_OPPerson的Store配置中的 SA_OPPerson 是 /system/data 下

yyywt · 发表于 2013-10-24 14:02:13

我怎么才能用/system/data里面的概念呢？谢谢

悲催的程序员 · 发表于 2013-10-24 14:02:19

你这种写法好像是实现不了了，ksql好像不能满足，只能绑定一个data

悲催的程序员 · 发表于 2013-10-24 14:05:22

要不把你的sql写成一个是视图在前端调用也行的绑定你的data

yyywt · 发表于 2013-10-24 14:09:26

那就要再增加一个概念了，哎

悲催的程序员 · 发表于 2013-10-24 14:09:29

HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put("ORACLE",orclSql);
sqlMap.put("MSSQL",msSql);
sqlMap.put("MYSQL",mySql);

return SQL.select(sqlMap,null,"/OA/doc/data"); 用平台的sql查询只要你绑定的data有查询条件就可以了

		自动登录	找回密码
密码			注册

[结贴] 数据查询问题