It is important how easily we can configure the connection pool with the use of a library. Also, it should be well documented and frequently updated.
The following table lists the differences between a Tomcat JDBC connection pool and HikariCP:
|Does not test connections on getConnection() by default.||Tests connections on getConnection().|
|Does not close abandoned open statements.||Tracks and closes abandoned connections.|
|Does not by default reset auto-commit and transaction levels for connections in the pool; users must configure custom interceptors to do this.||Resets auto-commit, transaction isolation, and read-only status.|
|Pool prepared statement properties are not used.||We can use pool prepared ...|