11.1.4. 支持连接池

11.1.4. Supported Connection Pools

Spring Boot uses the following algorithm for choosing a specific implementation:

• We prefer HikariCP for its performance and concurrency. If HikariCP is available, we always choose it.

• Otherwise, if the Tomcat pooling DataSource is available, we use it.

• Otherwise, if Commons DBCP2 is available, we use it.

• If none of HikariCP, Tomcat, and DBCP2 are available and if Oracle UCP is available, we use it.

If you use the spring-boot-starter-jdbc or spring-boot-starter-data-jpa “starters”, you automatically get a dependency to HikariCP.

You can bypass that algorithm completely and specify the connection pool to use by setting the spring.datasource.type property. This is especially important if you run your application in a Tomcat container, as tomcat-jdbc is provided by default.

Additional connection pools can always be configured manually, using DataSourceBuilder. If you define your own DataSource bean, auto-configuration does not occur. The following connection pools are supported by DataSourceBuilder:

• HikariCP

• Tomcat pooling Datasource

• Commons DBCP2

• Oracle UCP & OracleDataSource

• Spring Framework’s SimpleDriverDataSource

• H2 JdbcDataSource

• PostgreSQL PGSimpleDataSource

---

• SpringBoot会优先选择HikariCP连接池，因为它性能不错
• 如果依赖spring-boot-starter-jdbc or spring-boot-starter-data-jpa 会自动配置HikariCP连接池
• 如果配置了DataSourceBuilder，SpringBoot就不会自动配置连接池