HikariCP 整合spring

来源：互联网发布：随身带者淘宝去异世编辑：程序博客网时间：2024/06/06 23:57

HikariCP 源码地址，具体参数配置详细参考:

https://github.com/brettwooldridge/HikariCP

pom

<dependency>    <groupId>com.zaxxer</groupId>    <artifactId>HikariCP</artifactId>    <version>2.4.7</version></dependency>

spring-datasource.xml

<bean id = "dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close"><property name="driverClassName" value="${jdbc.driverClassName}" /><property name="jdbcUrl" value="${jdbc.url}" /><property name="username" value="${jdbc.username}" /><property name="password" value="${jdbc.password}" /><property name="maximumPoolSize" value="100" /><property name="minimumIdle" value="10" /><property name="connectionTestQuery" value="select 1" /><property name="dataSourceProperties"><props><prop key="cachePrepStmts">true</prop><prop key="prepStmtCacheSize">250</prop><prop key="prepStmtCacheSqlLimit">2048</prop><prop key="useServerPrepStmts">true</prop></props></property></bean>

0 0