新手入门SSM开源项目遇到的一点Bug

最新推荐文章于 2024-05-13 10:06:44 发布

ZYF__2015

最新推荐文章于 2024-05-13 10:06:44 发布

阅读量458

点赞数

文章标签： java spring

本文链接：https://blog.csdn.net/ZYF__2015/article/details/104516440

版权

使用IJEDA运行一个spring+spring mvc+mybats+Mysql的开源项目。

首先选择项目构建对应的方式

然后根据文件对应打开的方式

然后这个项目是通过pom.xml构建的，然后里面有许多依赖

选择自己需要的版本IJ就会提示导入。

遇到的异常

Exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Client does not support authentication protocol requested by server; consider upgrading MySQL client)

### The error may exist in jee/support/dao/AdminDao.xml

### The error may involve jee.support.dao.AdminDao.findByNameAndPwd

### The error occurred while executing a query

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)

org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)

javax.servlet.http.HttpServlet.service(HttpServlet.java:660)

org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)

org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

我首先看了第一句话Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Client does not support authentication protocol requested by server; consider upgrading MySQL client)

大致的意思是无法获得JDBC的连接，可能需要考虑MySQL客户端的升级。然后我查了一下我的版本基本是新的，然后发现我的依赖的数据库驱动包是旧的。

然后我上https://mvnrepository.com/上查询了最新的mysql-connector的版本，然后跟换版本，IJ自动提示import。

紧接着重启后再次爆出了异常！

### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (The server time zone value '�й��׼ʱ��' 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.)

### The error may exist in jee/support/dao/AdminDao.xml

### The error may involve jee.support.dao.AdminDao.findByNameAndPwd

### The error occurred while executing a query

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (The server time zone value '�й��׼ʱ��' 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.)