August 2, 2024

Spring Boot Database Connection Pooling

 https://medium.com/@ak123aryan/mastering-database-connection-pooling-in-spring-boot-a-comprehensive-guide-with-java-96b1ae8e93db

https://www.baeldung.com/spring-boot-tomcat-connection-pool

application.properties

spring.datasource.type =

"Fully qualified name of the connection pool implementation to use. By default, it is auto-detected from the classpath."

https://docs.spring.io/spring-boot/appendix/application-properties/index.html

HikariCP

spring.datasource.type = com.zaxxer.hikari.HikariDataSource

#default is 10
spring.datasource.hikari.maximum-pool-size=10
#default is same as max pool size
spring.datasource.hikari.minimum-idle=10
#default is 30 seconds
spring.datasource.hikari.connection-timeout=30000
#default is 600000 i.e 10 minutes
spring.datasource.hikari.idle-timeout=600000
#default is 1800000 i.e 30 minutes
spring.datasource.hikari.max-lifetime=1800000 
spring.datasource.hikari.pool-name=HikariConnPool

#spring.datasource.hikari.* =

https://medium.com/javarevisited/hikari-connection-pooling-5600d765e5ae

Tomcat JDBC Connection Pool

spring.datasource.type = org.apache.tomcat.jdbc.pool.DataSource

spring.datasource.tomcat.* =

Apache DBCP2

spring.datasource.type = org.apache.commons.dbcp2.BasicDataSource

spring.datasource.dbcp2.* =