Spring-Boot-2.0.0-M1版本将默认的数据库连接池从tomcat jdbc pool改为了hikari，这里主要研究下hikari的默认配置
spring-configuration-metadata.json
spring-boot-autoconfigure-2.0.0.M7.jar!/META-INF/spring-configuration-metadata.json
"sourceType"
:
"org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari"
,
"name"
:
"spring.datasource.hikari"
,
"sourceMethod"
:
"dataSource(org.springframework.boot.autoconfigure.jdbc.DataSourceProperties)"
,
"type"
:
"com.zaxxer.hikari.HikariDataSource"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.allow-pool-suspension"
,
"type"
:
"java.lang.Boolean"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.auto-commit"
,
"type"
:
"java.lang.Boolean"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.catalog"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.connection-init-sql"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.connection-test-query"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.connection-timeout"
,
"type"
:
"java.lang.Long"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.data-source-class-name"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.data-source-j-n-d-i"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.data-source-properties"
,
"type"
:
"java.util.Properties"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.driver-class-name"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.health-check-properties"
,
"type"
:
"java.util.Properties"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.health-check-registry"
,
"type"
:
"java.lang.Object"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.idle-timeout"
,
"type"
:
"java.lang.Long"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"deprecated"
:
true
,
"name"
:
"spring.datasource.hikari.initialization-fail-fast"
,
"type"
:
"java.lang.Boolean"
,
"deprecation"
:
{
}
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.initialization-fail-timeout"
,
"type"
:
"java.lang.Long"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.isolate-internal-queries"
,
"type"
:
"java.lang.Boolean"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.jdbc-url"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"deprecated"
:
true
,
"name"
:
"spring.datasource.hikari.jdbc4-connection-test"
,
"type"
:
"java.lang.Boolean"
,
"deprecation"
:
{
}
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.leak-detection-threshold"
,
"type"
:
"java.lang.Long"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.login-timeout"
,
"type"
:
"java.lang.Integer"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.max-lifetime"
,
"type"
:
"java.lang.Long"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.maximum-pool-size"
,
"type"
:
"java.lang.Integer"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.metric-registry"
,
"type"
:
"java.lang.Object"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.metrics-tracker-factory"
,
"type"
:
"com.zaxxer.hikari.metrics.MetricsTrackerFactory"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.minimum-idle"
,
"type"
:
"java.lang.Integer"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.password"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.pool-name"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.read-only"
,
"type"
:
"java.lang.Boolean"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.register-mbeans"
,
"type"
:
"java.lang.Boolean"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.scheduled-executor"
,
"type"
:
"java.util.concurrent.ScheduledExecutorService"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"deprecated"
:
true
,
"name"
:
"spring.datasource.hikari.scheduled-executor-service"
,
"type"
:
"java.util.concurrent.ScheduledThreadPoolExecutor"
,
"deprecation"
:
{
}
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.schema"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.transaction-isolation"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.username"
,
"type"
:
"java.lang.String"
"sourceType"
:
"com.zaxxer.hikari.HikariDataSource"
,
"name"
:
"spring.datasource.hikari.validation-timeout"
,
"type"
:
"java.lang.Long"
复制代码
HikariConfig
HikariCP-2.7.6-sources.jar!/com/zaxxer/hikari/HikariConfig.java
@SuppressWarnings({"SameParameterValue", "unused"})
public class HikariConfig implements HikariConfigMXBean
private static final Logger LOGGER = LoggerFactory.getLogger(HikariConfig.class)
private static final char[] ID_CHARACTERS = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ".toCharArray()
private static final long CONNECTION_TIMEOUT = SECONDS.toMillis(30)
private static final long VALIDATION_TIMEOUT = SECONDS.toMillis(5)
private static final long IDLE_TIMEOUT = MINUTES.toMillis(10)
private static final long MAX_LIFETIME = MINUTES.toMillis(30)
private static final int DEFAULT_POOL_SIZE = 10
//......
* Default constructor
public HikariConfig()
dataSourceProperties = new Properties()
healthCheckProperties = new Properties()
minIdle = -1
maxPoolSize = -1
maxLifetime = MAX_LIFETIME
connectionTimeout = CONNECTION_TIMEOUT
validationTimeout = VALIDATION_TIMEOUT
idleTimeout = IDLE_TIMEOUT
initializationFailTimeout = 1
isAutoCommit = true
String systemProp = System.getProperty("hikaricp.configurationFile")
if (systemProp != null) {
loadProperties(systemProp)
@Override
public void setConnectionTimeout(long connectionTimeoutMs)
if (sealed) throw new IllegalStateException("The configuration of the pool is sealed once started. Use HikariConfigMXBean for runtime changes.")
if (connectionTimeoutMs == 0) {
this.connectionTimeout = Integer.MAX_VALUE
else if (connectionTimeoutMs < 250) {
throw new IllegalArgumentException("connectionTimeout cannot be less than 250ms")
else {
this.connectionTimeout = connectionTimeoutMs
@Override
public void setIdleTimeout(long idleTimeoutMs)
if (sealed) throw new IllegalStateException("The configuration of the pool is sealed once started. Use HikariConfigMXBean for runtime changes.")
if (idleTimeoutMs < 0) {
throw new IllegalArgumentException("idleTimeout cannot be negative")
this.idleTimeout = idleTimeoutMs
@Override
public void setMaximumPoolSize(int maxPoolSize)
if (sealed) throw new IllegalStateException("The configuration of the pool is sealed once started. Use HikariConfigMXBean for runtime changes.")
if (maxPoolSize < 1) {
throw new IllegalArgumentException("maxPoolSize cannot be less than 1")
this.maxPoolSize = maxPoolSize
@Override
public void setMinimumIdle(int minIdle)
if (sealed) throw new IllegalStateException("The configuration of the pool is sealed once started. Use HikariConfigMXBean for runtime changes.")
if (minIdle < 0) {
throw new IllegalArgumentException("minimumIdle cannot be negative")
this.minIdle = minIdle
@Override
public void setValidationTimeout(long validationTimeoutMs)
if (sealed) throw new IllegalStateException("The configuration of the pool is sealed once started. Use HikariConfigMXBean for runtime changes.")
if (validationTimeoutMs < 250) {
throw new IllegalArgumentException("validationTimeout cannot be less than 250ms")
this.validationTimeout = validationTimeoutMs
public void validate()
if (poolName == null) {
poolName = generatePoolName()
else if (isRegisterMbeans && poolName.contains(":")) {
throw new IllegalArgumentException("poolName cannot contain ':' when used with JMX")
// treat empty property as null
catalog = getNullIfEmpty(catalog)
connectionInitSql = getNullIfEmpty(connectionInitSql)
connectionTestQuery = getNullIfEmpty(connectionTestQuery)
transactionIsolationName = getNullIfEmpty(transactionIsolationName)
dataSourceClassName = getNullIfEmpty(dataSourceClassName)
dataSourceJndiName = getNullIfEmpty(dataSourceJndiName)
driverClassName = getNullIfEmpty(driverClassName)
jdbcUrl = getNullIfEmpty(jdbcUrl)
// Check Data Source Options
if (dataSource != null) {
if (dataSourceClassName != null) {
LOGGER.warn("{} - using dataSource and ignoring dataSourceClassName.", poolName)
else if (dataSourceClassName != null) {
if (driverClassName != null) {
LOGGER.error("{} - cannot use driverClassName and dataSourceClassName together.", poolName)
// NOTE: This exception text is referenced by a Spring Boot FailureAnalyzer, it should not be
// changed without first notifying the Spring Boot developers.
throw new IllegalStateException("cannot use driverClassName and dataSourceClassName together.")
else if (jdbcUrl != null) {
LOGGER.warn("{} - using dataSourceClassName and ignoring jdbcUrl.", poolName)
else if (jdbcUrl != null || dataSourceJndiName != null) {
// ok
else if (driverClassName != null) {
LOGGER.error("{} - jdbcUrl is required with driverClassName.", poolName)
throw new IllegalArgumentException("jdbcUrl is required with driverClassName.")
else {
LOGGER.error("{} - dataSource or dataSourceClassName or jdbcUrl is required.", poolName)
throw new IllegalArgumentException("dataSource or dataSourceClassName or jdbcUrl is required.")
validateNumerics()
if (LOGGER.isDebugEnabled() || unitTest) {
logConfiguration()
private void validateNumerics()
if (maxLifetime != 0 && maxLifetime < SECONDS.toMillis(30)) {
LOGGER.warn("{} - maxLifetime is less than 30000ms, setting to default {}ms.", poolName, MAX_LIFETIME)
maxLifetime = MAX_LIFETIME
if (idleTimeout + SECONDS.toMillis(1) > maxLifetime && maxLifetime > 0) {
LOGGER.warn("{} - idleTimeout is close to or more than maxLifetime, disabling it.", poolName)
idleTimeout = 0
if (idleTimeout != 0 && idleTimeout < SECONDS.toMillis(10)) {
LOGGER.warn("{} - idleTimeout is less than 10000ms, setting to default {}ms.", poolName, IDLE_TIMEOUT)
idleTimeout = IDLE_TIMEOUT
if (leakDetectionThreshold > 0 && !unitTest) {
if (leakDetectionThreshold < SECONDS.toMillis(2) || (leakDetectionThreshold > maxLifetime && maxLifetime > 0)) {
LOGGER.warn("{} - leakDetectionThreshold is less than 2000ms or more than maxLifetime, disabling it.", poolName)
leakDetectionThreshold = 0
if (connectionTimeout < 250) {
LOGGER.warn("{} - connectionTimeout is less than 250ms, setting to {}ms.", poolName, CONNECTION_TIMEOUT)
connectionTimeout = CONNECTION_TIMEOUT
if (validationTimeout < 250) {
LOGGER.warn("{} - validationTimeout is less than 250ms, setting to {}ms.", poolName, VALIDATION_TIMEOUT)
validationTimeout = VALIDATION_TIMEOUT
if (maxPoolSize < 1) {
maxPoolSize = (minIdle <= 0) ? DEFAULT_POOL_SIZE : minIdle
if (minIdle < 0 || minIdle > maxPoolSize) {
minIdle = maxPoolSize
可以看到在set方法添加了参数校验，同时在configuration的构造器以及getConnection方法中也调用了validate方法
public HikariDataSource(HikariConfig configuration)
configuration.validate();
configuration.copyStateTo(this);
this.seal();
LOGGER.info("{} - Starting...", configuration.getPoolName());
pool = fastPathPool = new HikariPool(this);
LOGGER.info("{} - Start completed.", configuration.getPoolName());
@Override
public Connection getConnection() throws SQLException
if (isClosed()) {
throw new SQLException("HikariDataSource " + this + " has been closed.");
if (fastPathPool != null) {
return fastPathPool.getConnection();
HikariPool result = pool;
if (result == null) {
synchronized (this) {
result = pool;
if (result == null) {
validate();
LOGGER.info("{} - Starting...", getPoolName());
try {
pool = result = new HikariPool(this);
this.seal();
catch (PoolInitializationException pie) {
if (pie.getCause() instanceof SQLException) {
throw (SQLException) pie.getCause();
else {
throw pie;
LOGGER.info("{} - Start completed.", getPoolName());
return result.getConnection();
springboot的autoconfig是采用BeanUtils的反射来初始化HikariDataSource，走的是默认构造器，因此校验就依赖set方法以及后续的getConnection方法。
PoolBase.setLoginTimeout
HikariCP-2.7.6-sources.jar!/com/zaxxer/hikari/pool/PoolBase.java
* Set the loginTimeout on the specified DataSource.
* @param dataSource the DataSource
private void setLoginTimeout(final DataSource dataSource)
if (connectionTimeout != Integer.MAX_VALUE) {
try {
dataSource.setLoginTimeout(Math.max(1, (int) MILLISECONDS.toSeconds(500L + connectionTimeout)));
catch (Throwable e) {
LOGGER.info("{} - Failed to set login timeout for data source. ({})", poolName, e.getMessage());
这个在初始化的时候设定了loginTimeout，初始值为Math.max(1, (int) MILLISECONDS.toSeconds(500L + connectionTimeout))
springboot的HikariDataSource默认配置的默认值如下
构造器默认值
默认配置validate之后的值
validate重置
Math.max(1, (int) MILLISECONDS.toSeconds(500L + connectionTimeout))，为connectionTimeout+500ms转为秒数取整 与 1 取最大者
idleTimeout
MINUTES.toMillis(10) = 600000
600000
如果idleTimeout+1秒>maxLifetime 且 maxLifetime>0，则会被重置为0；如果idleTimeout!=0且小于10秒，则会被重置为10秒
leakDetectionThreshold
如果大于0且不是单元测试，则进一步判断：(leakDetectionThreshold < SECONDS.toMillis(2) or (leakDetectionThreshold > maxLifetime && maxLifetime > 0)，会被重置为0 . 即如果要生效则必须>0，而且不能小于2秒，而且当maxLifetime > 0时不能大于maxLifetime
initializationFailTimeout
isAutoCommit
isReadOnly
false
fasle
isAllowPoolSuspension
false
false
isIsolateInternalQueries
false
false
isRegisterMbeans
false
false
sealed
false
运行启动后这个标志为true，表示不再运行修改
poolName
HikariPool-1
catalog
connectionInitSql
connectionTestQuery
dataSourceClassName
schema
transactionIsolationName
dataSource
dataSourceProperties
threadFactory
scheduledExecutor
metricsTrackerFactory
metricRegistry
healthCheckRegistry
healthCheckProperties
Spring-Boot-2.0.0-M1-Release-Notes
