error:tomcat.jdbc.pool.ConnectionPool : Unable to create initial connections of pool.
java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long ->改mysql 5.1.46
1.很大原因是因为你安装的是mysql8.*以上的版本。与mysql5.1.20以上的版本都不兼容 将改为5.1.46即可
用5.1.47版本也行,加上useSSL=false(不然会有警告)。
报错:com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
2.mysql服务没有启动(上述报错)
mysql5.*配置:
application.properties:
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/how2java?characterEncoding=UTF-8
spring.datasource.username=your_localhost_name
spring.datasource.password=your_passwordformysql
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#和上面的url一样 可选一个
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/how2java?characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
pom.xml:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>
mysql 8.*配置:
application.properties: 注意driver改变了:
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
spring.datasource.username=root
spring.datasource.password=myroot
#另外一种url写法:
jdbc:mysql://localhost:3306/your_db?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
pom.xml:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.16</version>
</dependency>
都看到这了学到了还不点个关注点个赞吗,(哭。