通过反向生成本体引用外部数据库，出现下面的问题

xjtfq

刷新数据失败！ ,
执行KSQL出错, KSQL: SELECT Start_stop_time.* FROM Start_stop_time Start_stop_time LIMIT 0, 20
--> sql: SELECT Start_stop_time.ORG_NAME AS ORG_NAME, Start_stop_time.RECV_ID AS RECV_ID, Start_stop_time.START_TIME AS START_TIME, Start_stop_time.STOP_FLAG AS STOP_FLAG, Start_stop_time.STOP_TIME AS STOP_TIME, Start_stop_time.FID AS Start_stop_time, Start_stop_time.WELL_NAME AS WELL_NAME FROM start_stop_time Start_stop_time
--> binds: []
编码：JUSTEP150210
[url=]隐藏详细[/url]
java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) 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.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:723) at com.justep.x.bs.BusinessServerServlet.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 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 Start_stop_time.* FROM Start_stop_time Start_stop_time LIMIT 0, 20 --> sql: SELECT Start_stop_time.ORG_NAME AS ORG_NAME, Start_stop_time.RECV_ID AS RECV_ID, Start_stop_time.START_TIME AS START_TIME, Start_stop_time.STOP_FLAG AS STOP_FLAG, Start_stop_time.STOP_TIME AS STOP_TIME, Start_stop_time.FID AS Start_stop_time, Start_stop_time.WELL_NAME AS WELL_NAME FROM start_stop_time Start_stop_time --> binds: [] 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) ... 26 more Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT Start_stop_time.ORG_NAME AS ORG_NAME, Start_stop_time.RECV_ID AS RECV_ID, Start_stop_time.START_TIME AS START_TIME, Start_stop_time.STOP_FLAG AS STOP_FLAG, Start_stop_time.STOP_TIME AS STOP_TIME, Start_stop_time.FID AS Start_stop_time, Start_stop_time.WELL_NAME AS WELL_NAME FROM start_stop_time Start_stop_time, binds: []出错 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source) ... 31 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'shebeixinxi.start_stop_time' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.Util.getInstance(Util.java:383) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ... 32 more

jishuang

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

xjtfq

jishuang 发表于 2018-5-10 15:32
看tomcat控制台完整的错误信息

2018-05-10 16:09:14 excute stream action, params:{"accept":"application/json","action":"queryStart_stop_timeAction","actionFlag":"__action_0__","activity":"sbjbxxwh","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"ORG_NAME,RECV_ID,START_TIME,STOP_FLAG,STOP_TIME,Start_stop_time,WELL_NAME","limit":20,"offset":0,"variables":{}},"process":"/shebeixinxi/sbjbxx/process/sbjbxxgl/sbjbxxglProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"Start_stop_time","sequence":"ORG_NAME,RECV_ID,START_TIME,STOP_FLAG,STOP_TIME,Start_stop_time,WELL_NAME"},"transformIdcolumn":true,"useNamespace":true}}
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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.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:723)
at com.justep.x.bs.BusinessServerServlet.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 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 Start_stop_time.*  FROM Start_stop_time Start_stop_time LIMIT 0, 20
--> sql: SELECT  Start_stop_time.ORG_NAME AS ORG_NAME, Start_stop_time.RECV_ID AS RECV_ID, Start_stop_time.START_TIME AS START_TIME, Start_stop_time.STOP_FLAG AS STOP_FLAG, Start_stop_time.STOP_TIME AS STOP_TIME, Start_stop_time.FID AS Start_stop_time, Start_stop_time.WELL_NAME AS WELL_NAME FROM start_stop_time Start_stop_time
--> binds: []
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)
... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  Start_stop_time.ORG_NAME AS ORG_NAME, Start_stop_time.RECV_ID AS RECV_ID, Start_stop_time.START_TIME AS START_TIME, Start_stop_time.STOP_FLAG AS STOP_FLAG, Start_stop_time.STOP_TIME AS STOP_TIME, Start_stop_time.FID AS Start_stop_time, Start_stop_time.WELL_NAME AS WELL_NAME FROM start_stop_time Start_stop_time, binds: []出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 31 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'shebeixinxi.start_stop_time' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 32 more

jishuang

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'shebeixinxi.start_stop_time' doesn't exist

数据库中没有找到表

xjtfq

jishuang 发表于 2018-5-10 16:41
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'shebeixinxi.start_stop_time' does ...

需要在本地再建一个表吗？

jishuang

要在你模块配置的数据源中有才可以

xjtfq

jishuang 发表于 2018-5-11 08:51
要在你模块配置的数据源中有才可以

数据源里是DJZDH，但是错误信息中说shebeixinxi.start_stop不存在怎么办？改用baasData，数据源和数据库配置都做了，还是出现下面的错误：

HTTP Status 500 - 执行Action：shebeixinxi/DJZDH/queryStart_stop_time失败，Action[shebeixinxi/DJZDH/queryStart_stop_time]执行失败，获取数据库[java:comp/env/DJZDH]连接失败，可能原因：数据库已经关闭或者数据源配置错误

jishuang

DJZDH数据源连的数据库是什么?

xjtfq

jishuang 发表于 2018-5-11 10:01
DJZDH数据源连的数据库是什么?

数据库名youtian，数据源名称djzdh，改用baasData，数据源和数据库配置都做了，还是出现下面的错误：

HTTP Status 500 - 执行Action：shebeixinxi/DJZDH/queryStart_stop_time失败，Action[shebeixinxi/DJZDH/queryStart_stop_time]执行失败，获取数据库[java:comp/env/DJZDH]连接失败，可能原因：数据库已经关闭或者数据源配置错误

在重启tomcat的时候出现下面错误：
五月 11, 2018 10:17:19 上午 org.apache.catalina.core.AprLifecycleListener init
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\BeX5_V3.7\java\jre1.8\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;D:/BeX5_V3.7/studio//../java/jre1.8/bin/client;D:/BeX5_V3.7/studio//../java/jre1.8/bin;D:/BeX5_V3.7/studio//../java/jre1.8/lib/i386;C:\Windows;C:\Windows\System32;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\BeX5_V3.7\studio;;.
五月 11, 2018 10:17:20 上午 org.apache.coyote.http11.Http11Protocol init
严重: Error initializing endpoint
java.net.BindException: Address already in use: JVM_Bind <null>:8080
at org.apache.tomcat.util.net.JIoEndpoint.init(JIoEndpoint.java:549)
at org.apache.coyote.http11.Http11Protocol.init(Http11Protocol.java:180)
at org.apache.catalina.connector.Connector.initialize(Connector.java:1124)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:703)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:838)
at org.apache.catalina.startup.Catalina.load(Catalina.java:538)
at org.apache.catalina.startup.Catalina.load(Catalina.java:562)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:261)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.net.BindException: Address already in use: JVM_Bind
at java.net.DualStackPlainSocketImpl.bind0(Native Method)
at java.net.DualStackPlainSocketImpl.socketBind(DualStackPlainSocketImpl.java:106)
at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:190)
at java.net.ServerSocket.bind(ServerSocket.java:375)
at java.net.ServerSocket.<init>(ServerSocket.java:237)
at java.net.ServerSocket.<init>(ServerSocket.java:181)
at org.apache.tomcat.util.net.DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:50)
at org.apache.tomcat.util.net.JIoEndpoint.init(JIoEndpoint.java:538)
... 12 more
五月 11, 2018 10:17:20 上午 org.apache.catalina.core.StandardService initialize
严重: Failed to initialize connector [Connector[HTTP/1.1-8080]]
LifecycleException:  Protocol handler initialization failed: java.net.BindException: Address already in use: JVM_Bind <null>:8080
at org.apache.catalina.connector.Connector.initialize(Connector.java:1126)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:703)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:838)
at org.apache.catalina.startup.Catalina.load(Catalina.java:538)
at org.apache.catalina.startup.Catalina.load(Catalina.java:562)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:261)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
五月 11, 2018 10:17:20 上午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 492 ms
五月 11, 2018 10:17:20 上午 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
五月 11, 2018 10:17:20 上午 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.41
五月 11, 2018 10:17:20 上午 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor baas.xml
五月 11, 2018 10:17:20 上午 org.apache.catalina.loader.WebappClassLoader validateJarFile
信息: validateJarFile(D:\BeX5_V3.7\apache-tomcat\webapps\..\..\runtime\BaasServer\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
五月 11, 2018 10:17:20 上午 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor BusinessServer.xml
2018-05-11 10:17:21 License is used
2018-05-11 10:17:21 编码: JUSTEP150010; 提示: 授权不允许共享使用
com.justep.exception.BusinessException: 编码: JUSTEP150010; 提示: 授权不允许共享使用
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.business.server.BusinessLoaderListener.contextInitialized(Unknown Source)
at com.justep.x.loader.NativeLoaderListener.contextInitialized(Unknown Source)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Java HotSpot(TM) Client VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0

jishuang

任务管理器打开，把javaw.exe进程都关了再启动tomcat