Connection Pooling Concepts with HikariCP

Advanced16 min read•Updated: 2025-01-15

🏊 Connection Pooling Concepts with HikariCP

Introduction

Creating a physical database connection requires a complete TCP socket handshake, SSL key exchange, authentication, and backend thread allocation—taking between 50ms to 300ms per connection. In a high-traffic web application handling thousands of concurrent requests, opening and closing connections on each query cripples response times.

A Connection Pool maintains a pool of pre-warmed, active database connections ready for instantaneous reuse.

⚙️ Pool Lifecycle Mechanics

1┌────────────────────────────────────────────────────────┐
2│                   HIKARICP POOL                        │
3│   Active Conn 1 (In Use)        Active Conn 2 (In Use) │
4│   Idle Conn 3 (Ready) ◄───┐     Idle Conn 4 (Ready)    │
5└───────────────────────────┼────────────────────────────┘
6                            │ Borrow Connection (0.1ms!)
7                            │
8┌───────────────────────────┴────────────────────────────┐
9│                    Worker Thread                       │
10│ 1. Executes Query                                      │
11│ 2. conn.close()  ──► Returns connection back to pool!  │
12└────────────────────────────────────────────────────────┘

When your application calls connection.close(), HikariCP intercepts the call and does NOT terminate the TCP socket; it simply returns the connection to the idle pool!

🚀 Configuring HikariCP (Industry Standard)

HikariCP is the default, ultra-fast connection pool used by Spring Boot and enterprise Java frameworks.

1package com.mskinstitute.pool;
2 
3import com.zaxxer.hikari.HikariConfig;
4import com.zaxxer.hikari.HikariDataSource;
5import java.sql.Connection;
6import java.sql.SQLException;
7import javax.sql.DataSource;
8 
9public class HikariCPProvider {
10    private static final HikariDataSource dataSource;
11 
12    static {
13        HikariConfig config = new HikariConfig();
14        config.setJdbcUrl("jdbc:mysql://localhost:3306/msk_academy_db?useSSL=false");
15        config.setUsername("root");
16        config.setPassword("secretpassword");
17 
18        // Optimal Pool Sizing Formula: (CPU Cores * 2) + effective spindle count
19        config.setMaximumPoolSize(10);
20        config.setMinimumIdle(5);
21        config.setIdleTimeout(300000); // 5 minutes
22        config.setConnectionTimeout(20000); // 20 seconds wait timeout
23 
24        dataSource = new HikariDataSource(config);
25    }
26 
27    public static DataSource getDataSource() {
28        return dataSource;
29    }
30 
31    public static Connection getConnection() throws SQLException {
32        return dataSource.getConnection(); // Lightning fast borrow!
33    }
34}

Next Lesson

Java Reflection API: Class<T>, Methods, Fields, and Constructors

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
Transaction Management: setAutoCommit(false), commit(), and rollback()	Java Reflection API: Class<T>, Methods, Fields, and Constructors

Practice Quiz

Test your understanding of this lesson with 1 questions. Each question has one correct answer.

Previous Next

PreviousPrevNext

MSK Institute • Shikohabad

Loading Page Content...

Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...

Connecting serverPlease wait...

💻 Practical Labs🚀 Free Demo📜 Verified Certificates