SpringBoot MySQL Database Integration using HikariCP ^{It's Faster.} connection pooling

Sample Application with SpringBoot <-> JDBC <-> HikariCP <-> MySQL

Fast, simple, reliable. HikariCP is a "zero-overhead" production ready JDBC connection pool. At roughly 130Kb, the library is very light.

Project Requirements

• Amazon Corretto - JDK 1.8+ or higher.
• Apache Maven 3.8.1 - Maven Build Tool.
• Spring Framework - Spring Version 5.3.9.
• Oracle MySQL Database - Community Edition ,Version 5.8
• Eclipse IDE for Enterprise Java and Web Developers - IDE Version: 2021-06

HikariCP Maven Dependency

Maven artifact:

<dependency>
   <groupId>com.zaxxer</groupId>
   <artifactId>HikariCP</artifactId>
   <version>5.0.0</version>
</dependency>

Installation

This application requires Java 1.8+ , Maven build tool, MySQL 5.7x must be installed in the local machine.

• MySQL database server running locally with the respective port number, username and password.

• Create database, table as provided in springboot-hikari-jdbc-mysql/mysql_scripts/mysql_commands.sql

• Download sample application in your machine through GitHub.

• Import as a Maven project in your IDE (Here, Eclipse is used) of your choice.

• In your terminal window, Navigate to your project directory location and execute below command :

..\springboot-hikari-jdbc-mysql> mvn clean package -e -U

• Navigate to BootHikariMySqlApplication.java in your IDE and run this class as Java or SpringBoot application.

License

Licensed under GNU General Public License v3.0. Please see LICENSE for details.

Happy Learning!