通过视图反向生成的概念不能直接用于视图查询？

justep_hzj

我mysql数据库里面，有个视图a,我通过反向生成本体，形成一个概念A。
生成概念之后，我直接想通过此概念A，来查询数据里面视图中的数据，报错。
是不是此方式生成的概念，不能用于视图查询。

如果把概念A，点击“生成数据库”，更新一下，此操作，是生成了一个数据表，跟原来的视图没有关联了，这不是我想要的。

我就是想通过映射的概念，能操作底层数据库中的视图（仅查询），怎样解决？

jishuang

报错发具体的错误信息啊

justep_hzj

/x5/UI2/v_efcd9c70ec4c4d409f59762b577c0f49l_zh_CNs_desktopd_pc/canaan_test/template625/process/query/mainActivity.w?$pageType=view HTTP status: 500
隐藏详细
Error: /x5/UI2/v_efcd9c70ec4c4d409f59762b577c0f49l_zh_CNs_desktopd_pc/canaan_test/template625/process/query/mainActivity.w?$pageType=view HTTP status: 500 at XMLHttpRequest.s.onreadystatechange (http://localhost:8080/x5/UI2/v_294830e630a74beabb772f5eeb8e766bl_zh_CNs_desktopd_pc/system/core.min.js:71:2665)

jishuang

看tomcat控制台的完整错误信息

justep_hzj

2018-07-19 10:48:15 开始-WINDOW生成中间文件: /UI2/canaan_test/template625/process/query/mainActivity.w
2018-07-19 10:48:16 编码: JUSTEP001008; 提示: data[viewData]的idColumn[template625v]没有在select部分定义
javax.servlet.ServletException: com.justep.xbl.runtime.XBLException: 编码: JUSTEP001008; 提示: data[viewData]的idColumn[template625v]没有在select部分定义
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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: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.xbl.runtime.XBLException: 编码: JUSTEP001008; 提示: data[viewData]的idColumn[template625v]没有在select部分定义
        at com.justep.xbl.runtime.XBLException.create(Unknown Source)
        at com.justep.ui2.system.component.data.bizdata.BizDataDef.getIdColumn(Unknown Source)
        at BizData.getColDef(BizData.java:214)
        at BizData.processDataConfig(BizData.java:81)
        at Data.processData(Data.java:67)
        at Data.execute(Data.java:44)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        ... 17 more
七月 19, 2018 10:48:16 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
com.justep.xbl.runtime.XBLException: 编码: JUSTEP001008; 提示: data[viewData]的idColumn[template625v]没有在select部分定义
        at com.justep.xbl.runtime.XBLException.create(Unknown Source)
        at com.justep.ui2.system.component.data.bizdata.BizDataDef.getIdColumn(Unknown Source)
        at BizData.getColDef(BizData.java:214)
        at BizData.processDataConfig(BizData.java:81)
        at Data.processData(Data.java:67)
        at Data.execute(Data.java:44)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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: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)

jishuang

select中加报错的这个