验证Dao说连接数据库失败

Question

Caused by: org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

The error may exist in file [C:\Users\ASUS\Desktop\o2o\target\classes\mapper\AreaDao.xml]

The error may involve com.imooc.o2o.dao.AreaDao.queryArea

The error occurred while executing a query

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

老师验证Dao时候报这个错误

Answer 1

翔仔 2020-04-22 02:29:34

同学好 请问同学的mysql版本是不是8 如果是 请按照 

http://coding.imooc.com/lesson/144.html#mid=26875

进行配置

• 小波1997 #1

  翔仔老师，捕捉到你啦，这么晚还给同学解决答复~您是我见过最拼最负责最给力的了~，向你看齐~

• 翔仔 回复 小波1997 #2

  哈哈，同学看来比我还拼呀，大家一起加油，翔仔也会尽最大努力来帮助大家，能帮一个是一个：）

• Cris_hu 回复 翔仔 #3

  我也遇到了和题主一样的问题，解决了，spring-dao配置出了问题

Answer 2

Cris_hu 2020-08-19 18:24:19

我是重新找了和数据库配置相关的文件，最终在spring-dao下发现配置出了问题