flymeQAQflyme
2018-09-04 07:11
采纳率: 100%
浏览 1.5k
已采纳

本地安装MYSQL80,spring连接报错

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 org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
The error may exist in file [D:\chatroom2\WebChat-master\target\webchat\WEB-INF\classes\com\amayadream\webchat\mapping\UserMapper.xml]
The error may involve com.amayadream.webchat.dao.IUserDao.selectUserByUserid
The error occurred while executing a query
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
.......
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82)
....

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

java.lang.NullPointerException
com.mysql.jdbc.ConnectionImpl.getServerCharset(ConnectionImpl.java:3299)
com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1967)
com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1893)
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1287)


  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

5条回答 默认 最新

  • uoan 2018-09-07 10:05
    已采纳
    已采纳该答案
    打赏 评论
  • 一心向善_ 2018-09-04 07:26

    其他的查询是正确的吗?如果其他的查询是正确的,那就不是数据库连接的问题,如果其他的也不行,那就从数据库配置,数据源配置入手吧

    打赏 评论
  • _zming 2018-09-04 07:37

    Could not get JDBC Connection无法或取jdbc连接,看下jdbc的用户名密码啥的配的还对

    打赏 评论
  • tongkaiming 2018-09-04 07:52

    发一下你的数据库配置代码

    打赏 评论
  • 霸道流氓气质 2018-09-05 03:07

    无法连接的原因是mysql8与mysql5的加密方式不同。
    更改加密方式:
    mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
    执行后:
    Query OK, 0 rows affected (0.10 sec)
    更改密码:
    mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
    执行后:
    Query OK, 0 rows affected (0.35 sec)

    刷新

    打赏 评论