Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException报错

朴灿烈づ我的快乐病毒、 2022-12-11 15:23 155阅读 0赞

写了Controller类返回json数据文件时候报错  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTAzMDAyMw_size_16_color_FFFFFF_t_70_pic_center]

> This application has no explicit mapping for /error, so you are seeing this as a fallback.

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTAzMDAyMw_size_16_color_FFFFFF_t_70_pic_center 1]

**回到idear发现报错：**  
Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)  
The error may exist in edu/xalead/dao/ItemDao.java (best guess)  
The error may involve edu.xalead.dao.ItemDao.selectAll  
The error occurred while executing a query  
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)\] with root cause  
java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)

猜测应该是数据库连接的问题，去application.yaml文件下查看数据库连接。

spring:
      application:
        name: item-service
      datasource:
        url: jdbc:mysql://localhost:3306/

路径不完整所以连接有问题

spring:
      application:
        name: item-service
      datasource:
        url: jdbc:mysql://localhost:3306/jdd

补全你的数据库路径，结果还是发现同样的错误！

> Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)\] with root cause  
> java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)

再看一遍，原来是数据库的用户名和密码的错误！  
这波啊，这波是一石二鸟…

datasource:
        url: jdbc:mysql://localhost:3306/jdd
        username: root
        password:

把自己的数据库密码和用户名校正就好了！

最后在刷新一下网页，返回的数据与数据库中的数据匹配即成功。  
![在这里插入图片描述][20201003231002776.png_pic_center]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTAzMDAyMw_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/40737b2dd46a404ebd4e2e4a40627eae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTAzMDAyMw_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221123/b3bf5cde71d140f4b61195b10b773300.png
[20201003231002776.png_pic_center]: /images/20221123/760be767fbe04802921915f4b994cd53.png

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException报错

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException

相关 Mybatis异常Error querying database. Cause: java.lang.NullPointerException

相关 ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commun

相关 Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException报错

相关【mybatis】Error querying database. Cause: java.lang.NullPointerException

相关 Error querying database. Cause: java.sql.SQLNonTransientConnectionException:报错解决

相关遇到org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.

相关 Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection d

相关 ### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.ut

相关 Mybatis 报错 The error occurred while handling results，### Error querying database. Cause: java.lang.