spring整合ibatis出错，Cannot create PoolableConnectionFactory (Access denied for user 'root '@'localhost'

最新推荐文章于 2023-02-09 16:22:11 发布

xiaobingtao

最新推荐文章于 2023-02-09 16:22:11 发布

阅读量3.5k

点赞数

分类专栏： ibatis 异常文章标签： Spring iBATIS 异常

本文链接：https://blog.csdn.net/xiaobingtao/article/details/8960710

版权

ibatis 异常专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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:659)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

原因：在jdbc属性配置文件中
url=jdbc:mysql://localhost:3306/timesheet
user=root 等尾部有空格存在，导致异常