本地项目使用自带mysql数据库正常运行，部署后要使用阿里...

jishuang

发tomcat控制台完整的错误信息啊

linxingjie

jishuang 发表于 2019-4-2 14:00
发tomcat控制台完整的错误信息啊

2019-04-02 13:53:53 获取数据库[demo]连接失败，可能原因：数据库已经关闭或者数据源配置错误
javax.naming.NameNotFoundException: Name demo is not bound in this Context
        at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.SelectorContext.lookup(SelectorContext.java:152)
        at javax.naming.InitialContext.lookup(InitialContext.java:417)
        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 justep.IdleFishUser__do.queryIdlefish_user2(IdleFishUser__do.java:75)
        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)
2019-04-02 13:53:53 Action[justep/idleFishUser/queryIdlefish_user2]执行失败，获取数据库[demo]连接失败，可能原因：数据库已经关闭或者数据源配置错误
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: 获取数据库[demo]连接失败，可能原因：数据库已经关闭或者数据源配置错误
        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 justep.IdleFishUser__do.queryIdlefish_user2(IdleFishUser__do.java:75)
        ... 20 more
Caused by: javax.naming.NameNotFoundException: Name demo is not bound in this Context
        at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.SelectorContext.lookup(SelectorContext.java:152)
        at javax.naming.InitialContext.lookup(InitialContext.java:417)
        ... 24 more
com.justep.baas.action.ActionException: Action[justep/idleFishUser/queryIdlefish_user2]执行失败，获取数据库[demo]连接失败，可能原因：数据库已经关闭或者数据源配置错误
        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.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)
        ... 16 more
Caused by: com.justep.baas.data.sql.SQLException: 获取数据库[demo]连接失败，可能原因：数据库已经关闭或者数据源配置错误
        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 justep.IdleFishUser__do.queryIdlefish_user2(IdleFishUser__do.java:75)
        ... 20 more
Caused by: javax.naming.NameNotFoundException: Name demo is not bound in this Context
        at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.SelectorContext.lookup(SelectorContext.java:152)
        at javax.naming.InitialContext.lookup(InitialContext.java:417)
        ... 24 more

jishuang

确认tomcat\conf\context.xml中配置了数据源demo？
配置后确认重启tomcat了?

linxingjie

   tomcat的context.xml是这么写的 （账号密码我屏蔽掉了）

1.   <Resource name="demo" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://rm-m5en16u0b58z273z61o.mysql.rds.aliyuncs.com:3306/demo" username=“***”" password="***" maxActive="10" maxIdle="5"/>

复制代码

linxingjie

jishuang 发表于 2019-4-2 14:16
确认tomcat\conf\context.xml中配置了数据源demo？
配置后确认重启tomcat了?

恩。我都是关闭tomcat然后重启。

linxingjie

jishuang 发表于 2019-4-2 14:16
确认tomcat\conf\context.xml中配置了数据源demo？
配置后确认重启tomcat了?

需要从本地选择完阿里云的数据源在上传代码；还是只需要tomcat context.xml填写数据库的配置，然后重启？

jishuang

你在阿里云上部署的就要修改阿里云上的tomcat中的配置啊，连接的数据库要在阿里云上可以连通才可以

linxingjie

jishuang 发表于 2019-4-2 14:46
你在阿里云上部署的就要修改阿里云上的tomcat中的配置啊，连接的数据库要在阿里云上可以连通才可以 ...

这是没问题的 也是可以访问的。我本地也有测试过，是可以访问的。

linxingjie

jishuang 发表于 2019-4-2 14:46
你在阿里云上部署的就要修改阿里云上的tomcat中的配置啊，连接的数据库要在阿里云上可以连通才可以 ...

服务器上的 我有修改。还需要配置哪里吗?

jishuang

这个就是tomcat的web应用需要连接的数据库找不到的标准报错，这个错误就是没有找到数据源的配置，确认访问的tomcat和配置的tomcat是不是同一个