thepointman.dev_

Courses / Java

JDBC & Connection Pooling

intermediate7 lessons

JDBC from scratch: DriverManager, the three Statement types, ResultSet iteration. PreparedStatement as SQL injection prevention and batch optimisation. Why connection creation is expensive (TCP + auth + session). HikariCP's connection acquisition, the pool sizing formula (threads × (Cm-1) + 1), and leak detection configuration.

// Lessons

  1. 01

    JDBC from Scratch — DriverManager, Connection and the Three Statement Types

    soon
  2. 02

    ResultSet and Data Retrieval — Iteration, Column Access and Type Safety

    soon
  3. 03

    PreparedStatement — SQL Injection Prevention and Parameterisation

    soon
  4. 04

    Batch Operations — Sending 10,000 Rows Without 10,000 Round Trips

    soon
  5. 05

    Why Connection Pooling? — The True Cost of Connection Creation

    soon
  6. 06

    HikariCP Internals — Pool Sizing, Acquisition and Validation

    soon
  7. 07

    HikariCP Configuration — Timeouts, Leak Detection and Production Settings

    soon