Spring Boot & Microservice | Part 2 | Working with RDBMS | Hands On
00:00 - Introduction & Prerequisites
02:00 - The Engineering Challenge: Connecting to Remote Databases
06:17 - What is "Raw" JDBC? (The Boilerplate Problem)
08:51 - Why Closing Connections is Critical (TCP Resources)
12:08 - Deep Dive: What is Connection Pooling?
14:43 - The 48-Second Crash: A Real-World Resource Exhaustion Scenario
19:15 - Interview Challenge: Spot the Bug in this JDBC Code
23:59 - Enter JdbcTemplate: Spring's Abstraction Layer
26:24 - Exception Handling: SQL Exception vs. DataAccessException
30:35 - Domain Modeling: Mapping Tables to Java Objects
35:20 - Project Lombok: Removing the Boilerplate
37:16 - Demo Application: Setting up PostgreSQL with Docker
39:02 - pom.xml Walkthrough: Essential Dependencies
43:47 - application.yml: Configuring Database & Connection Pools
46:13 - Database Seeding: schema.sql & DataInitializer
47:40 - Live Demo: Testing Endpoints with Swagger UI
50:30 - implementing Update (PUT) Operations
52:43 - Architecture Summary & Next Steps
Codebase: https://github.com/subhamoy-burman/sp...