问题描述:
用docker-compose部署了一个mysql,然后项目部署时报错:
Could not create connection to database server. Attempted reconnect 3 times.
问题分析:
我百度了很久,好多都是配置连接池的url时加后缀
useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&failOverReadOnly=false&serverTimezone=GMT
发现并没有用,但是问题应该就出现在连接池这,后来发现,原来docker拉的镜像是mysql8,版本太高,要更换驱动,以及jar包
问题解决:
1.pom文件换mysql-connect-jar
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
2.驱动更换:
连接池com.mysql.jdbc.Driver 换成 com.mysql.cj.jdbc.Driver
成功!!!