Data & Transactions
JDBC evolution, connection pools, MyBatis, JPA, transaction propagation and Redis caching.
6 tutorials
01From Raw JDBC to JdbcTemplate: The Evolution of Data AccessStart from suffocating raw JDBC, refactor step by step to JdbcTemplate, and settle three fundamentals: SQL injection, resource leaks and exception translation.Intermediate63′02DataSource and HikariCP: Pool Internals and TuningWhy not open a connection per request? Why is HikariCP so fast? And how big should the pool be — pool internals, a parameter table and monitoring, turned into a tunable craft.Advanced42′03MyBatis in Practice: Mappers, Dynamic SQL and PagingStarting with mybatis-spring-boot-starter: the safety line between #{} and ${}, the dynamic SQL tag family, joins and paging — with both XML and annotation styles ready to copy.Intermediate63′04Spring Data JPA in Full: Repository Abstraction and JPQLThe persistence context and the four entity states, dirty checking and the flush moment, derived queries, @Query and JPQL, paging and dynamic criteria, N+1 and lazy loading, auditing and optimistic locking.Intermediate92′05Transactions Internals: How @Transactional Works and PropagatesWhy does one annotation commit or roll back for you? Proxy interception, connection binding to ThreadLocal, all seven propagation behaviors, dead-annotation scenarios and a peek at distributed transactions.Advanced51′06Redis and Spring Cache: The Caching Abstraction in PracticeFrom penetration, breakdown and avalanche to a complete Spring Cache + Redis setup: key design, serialization, expiry and the consistency trade-off.Intermediate56′