【mysql】org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection

谁借莪１个温暖的怀抱￠ 2024-02-19 21:04 56阅读 0赞

今天在启动一个旧项目的时候，总是出现这个错误

> org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException

具体报错如下：

2019-07-20 08:01:04,310 ERROR [PmsLoginAction.java:136] : login exception:
    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 com.alibaba.druid.pool.GetConnectionTimeoutException: loopWaitCount 0, wait millis 5001, active 0
    ### The error may exist in mybatis/mapper/PmsUser.Mapper.xml
    ### The error may involve wusc.edu.demo.user.dao.impl.PmsUserDaoImpl.findByUserNo
    ### The error occurred while executing a query
    ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: loopWaitCount 0, wait millis 5001, active 0
    	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
    	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364)
    	at com.sun.proxy.$Proxy11.selectOne(Unknown Source)
    	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
    	at wusc.edu.demo.user.dao.impl.PmsUserDaoImpl.findByUserNo(PmsUserDaoImpl.java:29)
    	at wusc.edu.demo.user.biz.PmsUserBiz.findUserByUserNo(PmsUserBiz.java:48)
    	at wusc.edu.demo.user.action.PmsLoginAction.userLogin(PmsLoginAction.java:60)
    	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:498)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
    	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
    	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
    	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563)
    	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417)
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    	at java.lang.Thread.run(Thread.java:748)

## 原因分析： ##

这个是导入的数据库连接包的问题，如下图，如果你导的包版本太低或者不符合，比如下面导的5.1.7的包，这个时候这个包是没有成功导入到工程中的（也导致上面的包也没导入，图标不一样），就会出现相关的错误

## 解决方案： ##

1、因为我的数据库是8.0.14版本，而项目中原有的jar包5.1.3 版本，这是因为jar版本太低了，为此我更换了jar版本，换成了8.0.16。  
2、更换jdbc.properties

# jdbc.url=jdbc\:mysql\://localhost\:3306/edu_demo?useUnicode\=true&characterEncoding\=utf-8
    换成如下链接，将原链接中的“\” 删除
    jdbc.url=jdbc:mysql://localhost:3306/edu_demo?useUnicode=true&characterEncoding=utf-8

3、修改druid配置文件中的驱动com.mysql.jdbc.Driver 为：com.mysql.cj.jdbc.Driver  
这是因为从mysql 8版本以后，驱动包都改成了com.mysql.cj.jdbc.Driver。

改成：

【mysql】org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关【mysql】org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection

相关 jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection 问题

相关 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection 问题处理

相关 IDEA Could not get JDBC Connection； nested exception is com.mysql.jdbc.exceptions

相关 Oracle数据源:org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection;

相关 Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nes

相关 Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not

相关报Could not get JDBC Connection的错误

相关 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection java.sql.SQ

相关【Java】 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection