AI写作智能体 自主规划任务,支持联网查询和网页读取,多模态高效创作各类分析报告、商业计划、营销方案、教学内容等。 广告
# :-: 集成HikariCP * [基础介绍](https://www.kancloud.cn/tracy5546/dynamic-datasource/2270657#_2) * [集成步骤](https://www.kancloud.cn/tracy5546/dynamic-datasource/2270657#_7) * [1\. 项目引入`HikariCP`依赖。](https://www.kancloud.cn/tracy5546/dynamic-datasource/2270657#1__HikariCP__9) * [2.参数配置。](https://www.kancloud.cn/tracy5546/dynamic-datasource/2270657#2_25) * [核心源码](https://www.kancloud.cn/tracy5546/dynamic-datasource/2270657#_70) # 基础介绍 * HikariCP Github[https://github.com/brettwooldridge/HikariCP](https://github.com/brettwooldridge/HikariCP) * HikariCP 文档[https://github.com/brettwooldridge/HikariCP/wiki](https://github.com/brettwooldridge/HikariCP/wiki) # 集成步骤 ## 1\. 项目引入`HikariCP`依赖。 [![](https://img.shields.io/maven-central/v/com.zaxxer/HikariCP.svg)](http://mvnrepository.com/artifact/com.zaxxer/HikariCP) ~~~ <dependency> <groupId>com.zaxxer</groupId> <artifactId>HikariCP</artifactId> <version>${version}</version> </dependency> ~~~ `SpringBoot2.x.x`默认引入了HikariCP,除非对版本有要求无需再次引入。 `SpringBoot 1.5.x`需手动引入,对应的版本请根据自己环境和HikariCP官方文档自行选择。 ## 2.参数配置。 1. 如果参数都未配置,则保持原组件默认值。 2. 如果配置了全局参数,则每一个数据源都会继承对应参数。 3. 每一个数据源可以单独设置参数覆盖全局参数。 ~~~ spring: datasource: dynamic: hikari: # 全局hikariCP参数,所有值和默认保持一致。(现已支持的参数如下,不清楚含义不要乱设置) catalog: connection-timeout: validation-timeout: idle-timeout: leak-detection-threshold: max-lifetime: max-pool-size: min-idle: initialization-fail-timeout: connection-init-sql: connection-test-query: dataSource-class-name: dataSource-jndi-name: schema: transaction-isolation-name: is-auto-commit: is-read-only: is-isolate-internal-queries: is-register-mbeans: is-allow-pool-suspension: data-source-properties: health-check-properties: datasource: master: username: root password: 123456 driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://xx.xx.xx.xx:3306/dynamic?characterEncoding=utf8&useSSL=false hikari: # 以下参数针对每个库可以重新设置hikari参数 max-pool-size: idle-timeout: # ...... ~~~ # 核心源码 `HikariCP数据源创建器`[https://github.com/baomidou/dynamic-datasource-spring-boot-starter/blob/master/src/main/java/com/baomidou/dynamic/datasource/creator/HikariDataSourceCreator.java](https://github.com/baomidou/dynamic-datasource-spring-boot-starter/blob/master/src/main/java/com/baomidou/dynamic/datasource/creator/HikariDataSourceCreator.java) `HikariCP参数配置类`[https://github.com/baomidou/dynamic-datasource-spring-boot-starter/blob/master/src/main/java/com/baomidou/dynamic/datasource/spring/boot/autoconfigure/hikari/HikariCpConfig.java](https://github.com/baomidou/dynamic-datasource-spring-boot-starter/blob/master/src/main/java/com/baomidou/dynamic/datasource/spring/boot/autoconfigure/hikari/HikariCpConfig.java)