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

xjtfq

jishuang 发表于 2018-5-11 10:29
任务管理器打开，把javaw.exe进程都关了再启动tomcat

tomcat可以启动了，但是下面的问题还在

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

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

jishuang

studio中测试数据源djzdh连接成功吗？

xjtfq

jishuang 发表于 2018-5-11 10:29
任务管理器打开，把javaw.exe进程都关了再启动tomcat

tomcat可以启动了，新建baasData还是有下面的错误

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

数据库用工具访问没有问题的。在db.config.m文件中也勾选了

xjtfq

jishuang 发表于 2018-5-11 10:47
studio中测试数据源djzdh连接成功吗？

连接成功的

jishuang

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

xjtfq

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

2018-05-11 15:38:33 开始-WINDOW生成中间文件: /UI2/shebeixinxi/sbjbxx/process/sbjbxxgl/sbjbxxwh.w
2018-05-11 15:38:36 结束-WINDOW生成中间文件: /UI2/shebeixinxi/sbjbxx/process/sbjbxxgl/sbjbxxwh.w
2018-05-11 15:38:36 开始-中间文件生成缓存文件: /UI2/shebeixinxi/sbjbxx/process/sbjbxxgl/sbjbxxwh.w
2018-05-11 15:38:36 结束-中间文件生成缓存文件: /UI2/shebeixinxi/sbjbxx/process/sbjbxxgl/sbjbxxwh.w
2018-05-11 15:38:47 获取数据库[java:comp/env/djzdh]连接失败，可能原因：数据库已经关闭或者数据源配置错误
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown system variable 'language')
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.justep.baas.data.DataUtils.getConnection(Unknown Source)
        at com.justep.baas.action.ActionContext.getConnection(Unknown Source)
        at com.justep.baas.action.CRUD.query(Unknown Source)
        at djzdh.Djzdh__do.queryStart_stop_time(Djzdh__do.java:43)
        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 com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        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: java.sql.SQLException: Unknown system variable 'language'
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        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:2541)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432)
        at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3870)
        at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3284)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2293)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
        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.ConnectionImpl.getInstance(ConnectionImpl.java:399)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
        at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 26 more
2018-05-11 15:38:47 Action[djzdh/djzdh/queryStart_stop_time]执行失败，获取数据库[java:comp/env/djzdh]连接失败，可能原因：数据库已经关闭或者数据源配置错误
java.lang.reflect.InvocationTargetException
        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 com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        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.baas.data.sql.SQLException: 获取数据库[java:comp/env/djzdh]连接失败，可能原因：数据库已经关闭或者数据源配置错误
        at com.justep.baas.data.DataUtils.getConnection(Unknown Source)
        at com.justep.baas.action.ActionContext.getConnection(Unknown Source)
        at com.justep.baas.action.CRUD.query(Unknown Source)
        at djzdh.Djzdh__do.queryStart_stop_time(Djzdh__do.java:43)
        ... 20 more

jishuang

http://bbs.wex5.com/forum.php?mo ... 8&pid=165372895

xjtfq

jishuang 发表于 2018-5-11 16:11
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=117288&pid=165372895

解决了，谢谢