Could not open JDBC Connection for transaction

最新推荐文章于 2025-11-08 19:06:14 发布
原创 最新推荐文章于 2025-11-08 19:06:14 发布 · 1.5w 阅读 · 4 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文详细介绍了在使用SpringMVC框架时遇到的MySQL8.0连接问题及解决方案，包括调整JDBC驱动版本和配置参数，以实现稳定的数据交互。

Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot load JDBC driver class ‘com.mysql.cj.jdbc.Driver’] with root cause
java.lang.ClassNotFoundException: com.mysql.jdbc.Drive

无法为事务打开JDBC连接

Servlet.service() for servlet [springmvc] in context with path [/stu_crm] threw exception [Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot load JDBC driver class 'com.mysql.cj.jdbc.Driver'] with root cause
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1352)
	at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1180)
	at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2131)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2033)
	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:211)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:447)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:277)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy18.selectAll(Unknown Source)
	at com.itcx.controller.DepartmentController.findAll(DepartmentController.java:19)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1156)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2527)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2516)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)

三月 07, 2019 10:17:39 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [springmvc] in context with path [/stu_crm] threw exception [Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot load JDBC driver class 'com.mysql.cj.jdbc.Driver'] with root cause
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1352)
	at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1180)
	at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2131)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2033)
	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:211)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:447)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:277)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy18.selectAll(Unknown Source)
	at com.itcx.controller.DepartmentController.findAll(DepartmentController.java:19)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1156)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2527)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2516)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)

解决方法

查看自己的数据库版本是否与自己所导入的连接数据库jar包匹配。
我的jar包是mysql-connector-java-5.1.40-bin.jar，而我的数据库版本是8.0，
所以要将mysql-connect-java版本改为8.0.11
dbconfig.properties中的jdbc.driver=com.mysql.jdbc.Driver
改为jdbc.driver=com.mysql.cj.jdbc.Driver
然后又出现了以下问题：
HTTP Status 500 - Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (The server time zone value ‘?D1ú±ê×?ê±??’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
只要将dbconfig.properties中的jdbc.url=jdbc:mysql://127.0.0.1:3306/database（数据库名）加上
？useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false&allowMultiQueries=true&allowPublicKeyRetrieval=true
这一大堆是我在使用mysql8.0版本出现过的问题百度然后加上去的，可以解决好几个问题，=。=！

dust_1
关注
HTTP Status 500 - Could not open JDBC Connection for transaction; nested exception is java.lang.NoCl
无知人生，记录点滴
03-09 1万+
HTTP Status 500 - Could not open JDBC Connection for transaction; nested exception is java.lang.NoClassDefFoundError: com/mchange/v2/sql/SqlUtilstype Exception reportmessage Could not open JDBC Connect
Could not open connection to jdbc:hive2://slave1:21050/;auth=noSasl: Connection refused
weixin_39848393的博客
03-28 3106
问题所在原因：impala server未开启开启impala：在master（主节点）上启动statestore，catalog/etc/init.d/impala-state-storestart/etc/init.d/impala-catalogstart在slave1-slave3（子节点，我这里子节点有三个）上依次启动server/etc/init.d/impala-serverstar...
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection f
最新发布
我是Java程序员廖志伟，感谢朋友们的支持！
11-08 692
💡 亲爱的技术伙伴们：你是否正在为这些问题焦虑——✅ 简历投出去杳无音信，明明技术不差却总卡在面试？✅ 每次终面都紧张不已，不知道面试官到底想要什么答案？✅ 技术知识点零零散散，遇到系统设计题就头脑一片空白？🎯这不是普通的面试题汇总，而是凝聚多年面试官经验的。我不仅告诉你答案，更帮你建立面试官的思维模式。🔗🎯 精准人群定位🔥 《》（完整技术体系）🚀⚡🌊🛠️🔒🔄👥🏗️🚀 立即行动，改变从现在开始！🔗不要再让面试成为你职业发展的绊脚石！用时间系统准备，轻松应对各种技术面试场景。💪。
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connectio
mybwu_com的专栏
10-11 3154
严重: StandardWrapper.Throwableorg.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections co...
Could not open JDBC Connection for transaction； nested exception is java.sql.SQLNonTransientConnecti
moteandsunlight的博客
08-15 1万+
使用MyBatis的SqlSession是不会自动关闭数据源连接的，需要使用Spring包装过的SelSqlSessionTemplate才会自动关闭数据源连接。所以每次执行一个请求对应的方法，都会占用一个数据源连接而不被释放，最终导致数据源连接池被占满，无法开启新的连接。配置数据连接的字段上加一个useSSL=false;
【Spring接MySQL数据库的坑】Could not open JDBC Connection for transaction
热门推荐
寒泉
01-19 7万+
原因 MySQL版本与JDBC版本不一致： 本地是MySQL8.0，使用的jar是mysql-connector-java-5.1.30 解决方式 升级mysql-connector-java到8.0.16即可，注意升级版本后jdbc.url要写时区。 db.properties配置如下： jdbc.driver = com.mysql.cj.jdbc.Driver jdbc.url = jdb...
Could not open JDBC Connection for transaction;
11-23
"Could not open JDBC Connection for transaction"是一个常见的错误，通常是由于数据库连接池中的连接已经关闭或无法创建新连接导致的。以下是可能导致此错误的一些原因和解决方法： 1. 数据库连接池中的连接已经...
Could not open JDBC Connection for transaction 是什么原因
09-14
"Could not open JDBC Connection for transaction" 是一个错误消息，通常在使用Java数据库连接（JDBC）进行事务处理时出现。这个错误的原因可能有很多种，包括但不限于以下几种情况： 1. 数据库配置错误：检查...
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException
02-06
当遇到 `Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException` 错误时，这通常意味着应用程序无法建立到数据库的有效连接。以下是几种可能的原因以及相应的解决方案： ###...
Could not open JDBC Connection for transaction； nested exception is org.apache.commons.dbcp.SQLNeste
七夜zippoe的博客
06-14 4653
在做负载均衡过程中，在多个服务器上部署了同样一套程序，数据库用的同一个，其中有两个服务器启动时正常，只要访问就报错如下：Could not open JDBC Connection for transaction;最终排查是因为服务器默认安装的是openJDK低版本（1.8.3xxxxx）,而项目需要的是(jdk1.8.9xxxxx)
Could not open JDBC Connection for transaction； nested exception is java.sql.SQLException: url not s
qq_63863019的博客
09-09 2万+
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: url not set
Could not open JDBC Connection for transaction； nested exception is java.sql.SQLException: Connectio
msgsun的博客
03-17 2万+
HTTP Status 500 – Internal Server Error Type Exception Report Message Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java
Could not open JDBC Connection for transaction； nested exception is java.lang.NullPointerException
可可的博客
03-23 893
这个一般是多数据源的问题，数据源里添加配置相应的数据库即可解决。
使用线程池插入数据报Could not open JDBC Connection for transaction 异常
weixin_34122810的博客
02-15 8409
2019独角兽企业重金招聘Python工程师标准>>> ...
Could not open JDBC Connection for transaction; nested exception is com.alibaba.druid.pool.DataSourc
qq_37632025的博客
07-26 1万+
现象：程序已启动得时候会 正常得跑一会儿，过不了一小会儿，就会出现这个错误（测试环境才会出现） 出现这个错误得原因： 1、出现在测试环境下使用 多线程， 多线程处理得逻辑中有 使用连接池连接数据库得操作（或者查询，插入等等） 2、因为主线程中运行一会儿，走完之后就会关闭数据库连接池，而多线程中得程序还在跑着 解决办法： 1：不在测试环境下运行，改为正常得control...
Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNest
lcz0615的专栏
04-27 1万+
翻译：无法打开的JDBC连接的事务;嵌套异常java.sql.SQLException：无效的状态，连接对象关闭....
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot报错
ouyuansz的博客
08-02 4万+
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create JDBC driver of cla...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值