Learn Java SQL, JDBC, Transactions, Connection Management & HikariCP

Kaufman Skill Map: JDBC as a System Boundary

Kaufman-based skill map for mastering Java SQL/JDBC as a production system boundary: mental models, invariants, failure modes, and deliberate practice roadmap.

The Java SQL Stack: java.sql, javax.sql, Driver, Database, Network

Deep dive into the Java SQL stack: java.sql, javax.sql, JDBC drivers, DriverManager, DataSource, network boundaries, database sessions, and production implications.

JDBC Core Object Model: Connection, Statement, PreparedStatement, CallableStatement, ResultSet

Deep dive into the JDBC core object model: Connection, Statement, PreparedStatement, CallableStatement, ResultSet, metadata, SQLException, object ownership, lifecycle, and production-grade usage rules.

Connection Lifecycle: From Borrow to Close

Production-grade connection lifecycle: acquisition, borrow-use-return, physical vs logical connections, pooled close semantics, state reset, leaks, thread ownership, and lifecycle invariants.

Statement Execution Model: Execute, Query, Update, Batch

Statement execution model in JDBC: executeQuery, executeUpdate, execute, large update counts, generated keys, batches, multiple results, timeout, cancellation, and production-grade execution invariants.

PreparedStatement Deep Dive: Binding, Type Mapping, Injection Defense

PreparedStatement deep dive for advanced Java engineers: parameter binding, type mapping, null handling, SQL injection boundaries, dynamic SQL safety, IN clauses, generated SQL, plan reuse, and common production pitfalls.

ResultSet Deep Dive: Cursor, Streaming, Fetch Size, Memory Pressure

ResultSet deep dive for advanced Java engineers: cursor model, result set type, concurrency, holdability, fetch size, streaming large results, memory pressure, null handling, row mapping, and production anti-patterns.

SQL Type Mapping: Java Types, JDBC Types, Database Types

SQL type mapping for advanced Java engineers: Java types, JDBC Types, JDBCType, database types, precision, scale, nullability, String and numeric semantics, UUID, JSON, arrays, enums, BLOB/CLOB, and vendor-specific type boundaries.

Time, Time Zone, and Temporal Correctness in JDBC

Temporal correctness for advanced Java/JDBC engineers: java.sql.Date, Time, Timestamp, java.time, JDBC 4.2+, Instant, LocalDate, LocalDateTime, OffsetDateTime, database timezone, JVM timezone, audit timestamps, business dates, DST, reporting, and temporal anti-patterns.

Transaction Fundamentals: Auto-Commit, Commit, Rollback

Transaction fundamentals for advanced Java/JDBC engineers: auto-commit, commit, rollback, transaction scope, exception paths, rollback failure, ambiguous commit, connection state, try-with-resources, transaction runner, and production-grade transaction invariants.

Transaction Isolation: Read Phenomena and Real Database Behavior

Deep dive transaction isolation untuk engineer Java/JDBC: SQL read phenomena, JDBC isolation constants, MVCC vs locking behavior, lost update, write skew, database-specific behavior, testing anomalies, dan decision framework isolation level.

Locking, Blocking, Deadlock, and Timeout Semantics

Production-grade guide to locking, blocking, deadlock, and timeout semantics in Java/JDBC systems: row locks, range locks, lock ordering, query timeout, lock timeout, pool timeout, transaction timeout, cancellation, retry, and incident diagnosis.

Savepoints and Partial Rollback

Savepoints and partial rollback in JDBC, including transaction semantics, correct usage patterns, failure handling, framework interaction, and anti-patterns.

Connection Management Patterns Without Frameworks

Connection management patterns without frameworks, including transaction runners, DAO/repository boundaries, resource ownership, exception translation, and anti-patterns.

DataSource Deep Dive: Why Production Code Should Prefer It

Deep dive into javax.sql.DataSource as the production-grade connection factory abstraction for JDBC applications, including DriverManager migration, vendor implementations, container-managed configuration, security, and operational boundaries.

Connection Pooling Fundamentals: Why Pools Exist and What They Are Not

Production-grade mental model of JDBC connection pooling as a bounded resource: why pools exist, what they solve, what they do not solve, queueing, sizing intuition, failure modes, and anti-patterns.

HikariCP Fundamentals: Architecture, Defaults, and Lifecycle

Production-grade introduction to HikariCP: architecture, lifecycle, HikariDataSource, HikariConfig, logical connection proxies, validation, housekeeper behavior, shutdown, observability, and common anti-patterns.

HikariCP Configuration Deep Dive

Deep dive into HikariCP configuration: essential properties, timeout semantics, pool sizing-related knobs, lifecycle properties, validation, leak detection, transaction defaults, metrics, JMX, driver properties, and production configuration anti-patterns.

Learn Java Sql Jdbc Part 019 Pool Sizing Queueing Database Capacity Workload Shape

Learn Java Sql Jdbc Part 020 Timeout Design Fail Fast Cascading Failure

Learn Java Sql Jdbc Part 021 Transaction Management In Application Architecture

Learn Java Sql Jdbc Part 022 Spring Transaction Management Through Jdbc Lens

Learn Java Sql Jdbc Part 023 Jdbctemplate Namedparameterjdbctemplate Safer Layers

Learn Java Sql Jdbc Part 024 Error Handling Sqlexception Sqlstate Vendor Codes Retryability

Retry, Idempotency, and Transaction Safety

Retry, idempotency, ambiguous commit, and transaction safety for production-grade Java JDBC systems.

Batch Processing and Bulk Data Operations

Batch processing and bulk data operations with JDBC, covering executeBatch, chunking, transaction size, generated keys, lock pressure, memory pressure, and production anti-patterns.

Large Objects and Streaming Data

Large Objects and Streaming Data in JDBC: BLOB/CLOB, InputStream/Reader, memory safety, transaction duration, driver behavior, and production-grade anti-patterns.

Observability: Metrics, Logs, Traces, and Database Correlation

Observability for JDBC and HikariCP: metrics, logs, traces, database correlation, dashboards, alerts, and incident-ready diagnosis.

Testing JDBC Code: Unit, Integration, Testcontainers, Failure Injection

Testing JDBC code with unit tests, integration tests, real databases, Testcontainers, transaction assertions, concurrency tests, and failure injection.

Security: SQL Injection, Least Privilege, Secrets, TLS, Auditability

Security at the Java JDBC boundary: SQL injection defense, dynamic SQL allowlists, least privilege, secrets, TLS, auditability, and production review checklists.

Production Failure Modes and Incident Playbooks

Production failure modes and incident playbooks for Java JDBC systems: pool exhaustion, connection leaks, slow queries, lock storms, deadlocks, failover, stale connections, migrations, and recovery strategy.

Patterns, Anti-Patterns, and Final Engineering Handbook

Final engineering handbook for Java SQL/JDBC systems: golden rules, patterns, anti-patterns, review checklists, decision frameworks, capstone drills, and series closure.