【测试可行】Sprng boot 配置 Druid 连接池

最新推荐文章于 2024-04-23 21:55:53 发布

爱看美剧真是太好了

最新推荐文章于 2024-04-23 21:55:53 发布

阅读量1.4k

点赞数 2

本文链接：https://blog.csdn.net/guozhaohui628/article/details/85045657

版权

写在前面

现在有点搞不懂这些写博客的，就不能自己测试下吗。搜篇 spring boot 配置 Druid连接池，浏览了几篇好像没一篇可行的。

因为版本迭代有问题可以理解，但是这些人提供的方法都不是这个原因

01 .pom 配置

		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.0.16</version>
		</dependency>

02 application.properties 配置

这里坑比较多，很容易出问题。

# 驱动配置信息
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.url = jdbc:mysql://127.0.0.1:3306/test1?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
spring.datasource.username = root
spring.datasource.password = 
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver

#连接池的配置信息
spring.datasource.initialSize=5
spring.datasource.minIdle=5
spring.datasource.maxActive=20
spring.datasource.maxWait=60000
spring.datasource.timeBetweenEvictionRunsMillis=60000
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=SELECT 1 FROM DUAL
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
spring.datasource.poolPreparedStatements=true
spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
spring.datasource.filters=stat,wall
spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

spring.datasource.url

serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

如果 url 的配置不添加 serverTimezone=UTC 会报如上错误

spring.datasource.driverClassName

Loading class 'com.mysql.jdbc.Driver'. This is deprecated. The new driver class is 'com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is genera