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

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

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

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

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 in JDBC: executeQuery, executeUpdate, execute, large update counts, generated keys, batches, multiple results, timeout, cancellation, and production-grade execution invariants.

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 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 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.

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 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.

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.

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 in JDBC, including transaction semantics, correct usage patterns, failure handling, framework interaction, and anti-patterns.

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

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.

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.

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

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.