复制书本上三大框架的项目,运行调试时遇到: 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
  • 打赏
  • 举报
回复
coolbamboo2008 2012-10-12
  • 打赏
  • 举报
回复
本地的话用户名密码是不是写错了
coolbamboo2008 2012-10-12
  • 打赏
  • 举报
回复
可能就连不上数据库,先确保你的数据库能够联通。从你自己的电脑访问一下
我是老孙 2012-10-12
  • 打赏
  • 举报
回复
用户名密码不对
abc0824 2012-10-12
  • 打赏
  • 举报
回复
用户名和密码错了吧,应该
高冷十三岁 2012-10-11
  • 打赏
  • 举报
回复
用户名或密码错了吧
桃园闲人 2012-10-11
  • 打赏
  • 举报
回复
驱动没有问题,用户名和密码不对,把你连接数据库的代码以贴出来看看,是不是将用户名和密码拼装到URI后面的,估计是拼接字符串错误。
  • 打赏
  • 举报
回复
你是不是那个登陆字符串组装错误了。
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 导入了吗

81,122

社区成员

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

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