JSE Module 6 – Lab 3 Workshop: Connecting to Databases

Separate workshop lab for the post-workshop skills application. This repo contains starter code in which the async skills application is already completed (database configuration with env vars, JPA custom query findByPriceLessThan, /api/products/below). Learners implement only JdbcTemplate (product count) and transaction documentation (transaction_notes.txt).

Contents

• Starter code: Spring Boot project with async part done; TODOs only in ProductReportService.getProductCount() and in creating transaction_notes.txt.
• Skillable instructions: skillable-lab-w3-connecting-databases.md (upload as lab Instructions in Skillable for the Workshop 3 skills application).

Relation to other labs

• Async lab (lab-03-connecting-databases): Learners do config + JPA custom query. Instructions: skillable-lab-u3-connecting-databases-async.md.
• Workshop demo (lab-03-connecting-databases-demo): Instructor shows full solution including JdbcTemplate and @Transactional.
• This workshop lab: Starter has async completed; learners add JdbcTemplate and document transaction behaviour.

Prerequisites

• Java 17+
• Maven 3.6+ (or ./mvnw)

Quick start

./mvnw spring-boot:run

Complete Task 1 (JdbcTemplate count) and Task 2 (transaction_notes.txt) as described in the Skillable instructions.

Pushing to Git

cd output/jse/module-06/lab-03-connecting-databases-workshop
git init
git add .
git commit -m "Initial commit: Lab 3 Workshop starter (async completed) and Skillable instructions"
git remote add origin <your-workshop-repo-url>
git push -u origin main

Lab alignment

• Module: JSE Module 6 – Building APIs in Java
• Unit: 3 – Connecting to Databases
• Focus: Workshop skills application only (JdbcTemplate, transaction documentation); async skills application is pre-completed in the starter.