Could not open JDBC Connection for transaction; nested exc [用户名密码错误异常】

最新推荐文章于 2023-09-02 09:12:08 发布
最新推荐文章于 2023-09-02 09:12:08 发布
阅读量1.5w 收藏
点赞数
分类专栏： 项目异常
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/csdnZCjava/article/details/74332651
版权

HTTP Status 500 - Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))

type Exception report

message Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))

description The server encountered an internal error that prevented it from fulfilling this request.

exception 

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:980)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause 

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
	org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:245)
	org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
	org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427)
	org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
	com.sun.proxy.$Proxy20.getAllUser(Unknown Source)
	com.heitian.ssm.controller.UserController.showUser(UserController.java:29)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:178)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:444)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:432)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause 

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
	org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:204)
	org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
	org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427)
	org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
	com.sun.proxy.$Proxy20.getAllUser(Unknown Source)
	com.heitian.ssm.controller.UserController.showUser(UserController.java:29)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:178)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:444)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:432)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause 

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:928)
	com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4736)
	com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1342)
	com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2502)
	com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2535)
	com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2320)
	com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
	com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)
	org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
	org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
	org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
	org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:204)
	org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
	org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427)
	org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
	com.sun.proxy.$Proxy20.getAllUser(Unknown Source)
	com.heitian.ssm.controller.UserController.showUser(UserController.java:29)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:178)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:444)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:432)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.78 logs.


如果报了以上异常：

解决办法：查看jdbc.properties中的用户名和密码是否正确。


相关网站链接：http://bbs.csdn.net/topics/390240240

csdnZCjava
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Could not open JDBC Connection for transaction； nested exception is : Communications link failure
wangxuelei036的博客
08-06 1万+
CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 2,297,746.
DBCP连接池配置参数
ZERO
10-21 8029
DBCP连接池配置参数 initialSize="10"           初始化连接，连接池启动时创建的初始化连接数量（默认值为0） maxActive="80"           最大活动连接，连接池中可同时连接的最大的连接数（默认值为8） minIdle="10"           最小空闲连接，连接池中最小的空闲的连接数，低于这个数量会被创建新的连接（默认
Could not open JDBC Connection for transaction； nested exception is com.alibaba.druid.pool.DataSourc
帝上无天的博客
07-08 2万+
项目中使用了阿里的 Druid 数据库，刚开始很正常，后来发现出现了问题，问题如下： 日志比较多，重点有以下几个： 其他的我们截图看看： 上图打码的地方是公司的dao层查数据库的代码。意思很明白了，就是因为在进行查询的时候，连接已经关闭了，而且会一直刷出这样的日志。综合网上大家的意见，可能原因主要有以下几点： 博主给的答案是： 参考：Druid连接池自动关闭其实这个答案和上面一个的说法一致，不过这个给出了解决方案：是否在定时器中手动获取了 DataSource，然后使用后关闭了或者用完后长期不再用被连接池自
单元测试 报 Could not open JDBC Connection for transaction； nested exception is com.mysql.jdbc.exceptions
u010241767的博客
09-02 1445
Communications link failure 异常：The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
HTTP Status 500 - Could not open JDBC Connection for transaction; nested exception is java.lang.NoCl
weixin_34348805的博客
03-09 788
HTTP Status 500 - Could not open JDBC Connection for transaction; nested exception is java.lang.NoClassDefFoundError: com/mchange/v2/sql/SqlUtils type Exception report ...
dbcp 连接池不合理的锁导致连接耗尽解决方案
01-20
DBCP（Database Connection Pool）是Apache的一个开源项目，提供了一个基于Java的数据源连接池实现。在上述问题中，应用程序遇到了由于连接池不合理的锁机制导致的连接耗尽问题，表现为无法从连接池获取新的数据库...
Could not roll back Hibernate transaction.doc
12-08
Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed 这表明Hibernate事务回滚操作失败，导致事务不能正确回滚。 二、问题原因 该问题的...
Oracle Universal Connection Pool for JDBC Developer’s Guide 11g
06-17
Oracle Universal Connection Pool for JDBC Developer’s Guide 11g Release 2 (11.2) 是一份详尽的文档，旨在帮助开发者充分利用Oracle公司提供的通用连接池技术，该技术适用于JDBC（Java Database Connectivity）...
kotlin-coroutines-jdbc：用于使用Kotlin Coroutines与阻止JDBC驱动程序进行交互的库
02-06
在kotlin-coroutines-jdbc中，你可以利用`withTransaction`函数来包裹一组数据库操作，形成一个原子性的事务，保证数据的一致性和完整性。即使在事务内部出现异常，所有更改也会被回滚，保持数据库状态的完整。 ...
fabric:error validating channel creation transaction for new channel ‘mychannel’
01-20
然而，当你遇到“fabric:error validating channel creation transaction for new channel ‘mychannel’”这样的错误时，这通常意味着在尝试创建名为“mychannel”的新通道时发生了问题。下面我们将深入分析这个...
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 java.sql.SQLException: Connectio
mybwu_com的专栏
10-11 2804
严重: StandardWrapper.Throwableorg.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections co...
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for
技匠而已
01-22 2万+
博客来源：SSM中本来可以连接数据库。部署上之后长时间不操作不能连接数据库 MessageRequest processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.cj.jdbc.exception..
【错误】：Could not open JDBC Connection for transaction; nested exception is: Communications link failur...
11-22 1052
# #错误日志 2016-11-10 16:19:20,834 ERROR [org.quartz.core.JobRunShell] - Job DEFAULT.jobtask threw an unhandled Exception: org.springframework.scheduling.quartz.JobMethodInvocationFailedExcepti...
使用线程池插入数据报Could not open JDBC Connection for transaction 异常
热门推荐
等待未果 ~~
09-01 9万+
前言 原因分析 解决方案 错误信息 前言 使用线程池插入数据报Could not open JDBC Connection for transaction 异常 Could not open JDBC Connection for transaction; nested exception is com.alibaba.druid.pool.DataSourceClose...
Hibernate开发中常见错误总结
涂作权的博客
10-06 3万+
org.hibernate.MappingException: Unknown entity: cn.itcast.hibernate717.helloworld.Person hibernate框架根本不知道Person这个持久化类的存在 Caused by: java.sql.SQLException: Field 'id' doesn't have a default value 如果
could not open jdbc connection for transaction; nested exception is java.sql.exception
最新发布
11-10
"could not open jdbc connection for transaction; nested exception is java.sql.exception"这个错误通常是由于数据库连接池中的连接数已满或数据库连接配置错误导致的。以下是解决此问题的一些方法： 1. 检查...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值