Could not get JDBC Connection数据库连接失败

[weixin_43273931]

各位大佬求解答这是怎么回事？

[tianfang]

贴出你的数据库配置部分

[tianfang]

用文本把错误信息完整贴出来

[tianfang]

JSR 356 WebSocket (Java WebSocket 1.0) support is not available when running on Java 6. 你的myeclipse太老，还是jdk1.6 Cannot create PoolableConnectionFactory (Access denied for user 'admin'@'localhost' (using password: YES)) 密码、权限错误，mysql管理员用户是root

[world先森]

本地启动MySQL，cmd进去输入用户名密码还能否登录进去，应该是用户名或者密码不正确。

[weixin_43273931]

引用 7 楼 MaLo Fei 的回复:

本地启动MySQL，cmd进去输入用户名密码还能否登录进去，应该是用户名或者密码不正确。

密码正确，CMD能进去

[weixin_43273931]

引用 6 楼 tianfang 的回复:

JSR 356 WebSocket (Java WebSocket 1.0) support is not available when running on Java 6.
你的myeclipse太老，还是jdk1.6

Cannot create PoolableConnectionFactory (Access denied for user 'admin'@'localhost' (using password: YES))
密码、权限错误，mysql管理员用户是root

原来可以的啊，一个月没运行不行了，不清楚搞到哪里了

[weixin_43273931]

是这个吗大佬

[weixin_43273931]

引用 2 楼 tianfang 的回复:

用文本把错误信息完整贴出来

2020-10-8 9:12:35 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:\Program Files\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\bin;C:\Program Files\tomcat\apache-tomcat-7.0.56\bin
2020-10-8 9:12:35 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-bio-8080"]
2020-10-8 9:12:35 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-bio-8009"]
2020-10-8 9:12:35 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 291 ms
2020-10-8 9:12:35 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
2020-10-8 9:12:35 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/7.0.56
2020-10-8 9:12:35 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\cgm0guahaoyindao
2020-10-8 9:12:37 org.apache.tomcat.websocket.server.WsSci onStartup
信息: JSR 356 WebSocket (Java WebSocket 1.0) support is not available when running on Java 6. To suppress this message, run Tomcat on Java 7, remove the WebSocket JARs from $CATALINA_HOME/lib or add the WebSocket JARs to the tomcat.util.scan.DefaultJarScanner.jarsToSkip property in $CATALINA_BASE/conf/catalina.properties. Note that the deprecated Tomcat 7 WebSocket API will be available.
2020-10-8 9:12:37 org.apache.catalina.core.ApplicationContext log
信息: No Spring WebApplicationInitializer types detected on classpath
log4j:WARN No appenders could be found for logger (org.springframework.web.context.support.StandardServletEnvironment).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
2020-10-8 9:12:37 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\cgm0guahaoyindao has finished in 2,188 ms
2020-10-8 9:12:37 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\docs
2020-10-8 9:12:37 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\docs has finished in 23 ms
2020-10-8 9:12:37 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\examples
2020-10-8 9:12:38 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2020-10-8 9:12:38 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2020-10-8 9:12:38 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@533790eb')
2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\examples has finished in 188 ms
2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\host-manager
2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\host-manager has finished in 31 ms
2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\manager
2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\manager has finished in 30 ms
2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\NISD
2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\NISD has finished in 195 ms
2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\ROOT
2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\ROOT has finished in 44 ms
2020-10-8 9:12:38 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-bio-8080"]
2020-10-8 9:12:38 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-bio-8009"]
2020-10-8 9:12:38 org.apache.catalina.startup.Catalina start
信息: Server startup in 2723 ms
2020-10-8 9:12:50 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring FrameworkServlet 'springmvc'
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1815401b] was not registered for synchronization because synchronization is not active
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1815401b]
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'admin'@'localhost' (using password: YES))
### The error may exist in com/mapper/JcpeizhiMapper.xml
### The error may involve com.mapper.JcpeizhiMapper.selectAll
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'admin'@'localhost' (using password: YES))
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
at $Proxy9.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:198)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:119)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)

at $Proxy24.selectAll(Unknown Source)
at com.dao.JcpeizhiDao.getJcpeizhiList(JcpeizhiDao.java:17)
at com.service.JcpeizhiService.queryJcpeizhis(JcpeizhiService.java:18)
at com.action.JcpeizhiAction.getJcpeizhis(JcpeizhiAction.java:220)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:746)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:687)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:915)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:822)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:796)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal

[KeepSayingNo]

信息: Deploying web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\host-manager 2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory 你的tomcat都用7了，建议升级JDK到1.7

[vcshcn]

已经说了是jcpei.. .xml中的select all错了，就改那里呗

[weixin_43273931]

引用 10 楼 KeepSayingNo 的回复:

信息: Deploying web application directory C:\Program Files\tomcat\apache-tomcat-7.0.56\webapps\host-manager
2020-10-8 9:12:38 org.apache.catalina.startup.HostConfig deployDirectory
啊
你的tomcat都用7了，建议升级JDK到1.7

我是1.8版本啊