Learning Spring Boot, Zero to Cloud, Ep 41 - Stored Procedures & TestContainers (BONUS!) скачать в хорошем качестве

Learning Spring Boot, Zero to Cloud, Ep 41 - Stored Procedures & TestContainers (BONUS!)

In this video, we dive deep into how to call *stored procedures* using *raw JdbcTemplate* in Spring Boot. From understanding the basics of stored procedures to real-world examples involving input/output parameters, return values, and reading `ResultSet`s—this is your practical guide to mastering `CallableStatement` execution manually. We’ll walk step-by-step through syntax, usage, exception handling, and best practices—all explained clearly with code snippets and diagrams. Whether you’re brushing up on your Spring JDBC skills or learning how to work closer to the database, this video is for you! --- 🧠 *What You’ll Learn* 🧩 What is a Stored Procedure? 🚀 Quick JdbcTemplate refresher 📜 How to call procedures and functions manually 🔁 Input, Output, and Return value handling 📦 How to manage multiple output parameters 🔍 Working with ResultSets ⚠️ Exception & Transaction handling 🧽 Limitations, pitfalls, and best practices --- ⏱️ *Timestamps* 00:00 - Intro 01:10 - What is a Stored Procedure? 06:34 - JdbcTemplate_ A quick review 07:21 - Theory Behind Raw Procedure Calls 08:24 - Procedure vs Function Syntax 10:36 - Input Parameters Only 12:01 - Output Parameters 13:32 - Calling Functions with Return Values 15:12 - Handling Multiple Output Params 15:51 - Reading ResultSets 18:19 - JdbcTemplate good practices 22:57 - Code Walkthrough (BONUS: TestContainers) #SpringBoot #JdbcTemplate #StoredProcedures #JavaDevelopment #SpringJDBC #SQLinJava #CallableStatement #JavaTips #SpringBootTutorial #BackendDevelopment #CodeWithJosé #DatabaseIntegration #JavaProgramming