复制书本上三大框架的项目，运行调试时遇到： Could not open JDBC Connection for transaction; nested exc

alongwilliam 2012-10-11 05:20:36
具体的错误提示如下：

HTTP Status 500 -

type Exception report

message

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

exception

javax.servlet.ServletException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user 'root'@'localhost' (using password: YES)"
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:523)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
com.REP.processor.EncodingProcessor.process(EncodingProcessor.java:16)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user 'root'@'localhost' (using password: YES)"
org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:219)
org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:283)
org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:226)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:89)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
$Proxy1.repast(Unknown Source)
com.REP.action.EmployeeOperateAction.employeeRepast(EmployeeOperateAction.java:38)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
com.REP.processor.EncodingProcessor.process(EncodingProcessor.java:16)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause

java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user 'root'@'localhost' (using password: YES)"
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1803)
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:2353)
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:750)
com.mysql.jdbc.Connection.createNewIO(Connection.java:1627)
com.mysql.jdbc.Connection.<init>(Connection.java:427)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:395)
java.sql.DriverManager.getConnection(DriverManager.java:582)
java.sql.DriverManager.getConnection(DriverManager.java:154)
org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:291)
org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:277)
org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:259)
org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:241)
org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:182)
org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:283)
org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:226)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:89)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
$Proxy1.repast(Unknown Source)
com.REP.action.EmployeeOperateAction.employeeRepast(EmployeeOperateAction.java:38)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
com.REP.processor.EncodingProcessor.process(EncodingProcessor.java:16)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs.

Apache Tomcat/6.0.35


折腾了一下午，望有经验的大牛赐教。
...全文
29583 11 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
11 条回复
切换为时间正序
请发表友善的回复…
发表回复
coooliang 2012-10-23
  • 打赏
  • 举报
 回复
myblog
coolbamboo2008 2012-10-12
  • 打赏
  • 举报
 回复
本地的话用户名密码是不是写错了
coolbamboo2008 2012-10-12
  • 打赏
  • 举报
 回复
可能就连不上数据库，先确保你的数据库能够联通。从你自己的电脑访问一下
我是老孙 2012-10-12
  • 打赏
  • 举报
 回复
用户名密码不对
abc0824 2012-10-12
  • 打赏
  • 举报
 回复
用户名和密码错了吧，应该
高冷十三岁 2012-10-11
  • 打赏
  • 举报
 回复
用户名或密码错了吧
桃园闲人 2012-10-11
  • 打赏
  • 举报
 回复
驱动没有问题，用户名和密码不对，把你连接数据库的代码以贴出来看看，是不是将用户名和密码拼装到URI后面的，估计是拼接字符串错误。
JavaNet的牛肉粉丝 2012-10-11
  • 打赏
  • 举报
 回复
你是不是那个登陆字符串组装错误了。
z_yes163 2012-10-11
  • 打赏
  • 举报
 回复


回复于：2012-10-11 17:24:29
Access denied for user 'root'@'localhost'
用户登录失败.
楼主检查下用户名和密码
jackson_fighting 2012-10-11
  • 打赏
  • 举报
 回复
Access denied for user 'root'@'localhost'
用户登录失败.
楼主检查下用户名和密码
zhanglujie2008 2012-10-11
  • 打赏
  • 举报
 回复
ojdb14.jar 导入了吗
【Mysql】Could not open JDBC Connection for transaction 异常分析和解决
1.问题: 异常：Could not open JDBC Connection for transaction; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60000, active 0, maxActive 20, creating 0, createErrorCount 2493 原因： maxActive/ maxWait: 最大活动连接数，即连接池中最大连接数。当程
MYSQL报错-CannotCreateTransactionException: Could not open JDBC Connection for transaction 问题分析及解决方案
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLTransientConnectionException: HikariPool-3 - Connection is not available, request timed out after 30001ms.
Could not open JDBC Connection for transaction； nested exception is : Communications link failure
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.
Could not open JDBC Connection for transaction
操做：访问20次数据库没问题，超过20次调用后报如下错误 详细报错： org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.tomcat.dbcp.dbcp....
Could not open JDBC Connection for transaction； nested exception is java.sql.SQLException: url not s
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: url not set
Web 开发

81,122

社区成员

341,744

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章