1. The purpose of this post
We know that springboot use the tomcat connection pool by default in spring boot 1.x applications. What should we do if we want to change to hikari connection pool? It’s very easy ,let’s start.
- SpringBoot 1.x
- Java 1.8+
3. The solution
3.1 Remove tomcat connection pool dependency from your POM.xml
If springboot find the tomcat connection pool jar file in the classpath, then it would use it as the default connection pool. We must remove it.
3.2 Change your application.properties like this
Pay attention to the spring.datasource.jdbcUrl, the original configuration is spring.datasource.url.
3.3 Write an aspect to verify that we use the hikariCP
Refer to this article to debug and view the internal connection pool that springboot uses.
3.4 Run the code
we should get this:
As you can see, change the default connection pool in spring boot 1.x is very easy. If you have any question,just contact me.