JSE Module 6 – Lab 3 Async: Connecting to Databases

Self-contained Skillable lab for the async skills application (Unit 3 – Connecting to Databases). Learners complete config (env vars) and JPA custom query here; the workshop lab is a separate repo with this work completed.

Contents

• Starter code: Spring Boot project with Product entity, repository, service, and JdbcTemplate report service stubs. TODOs for config and JPA query.
• Async instructions: skillable-lab-u3-connecting-databases-async.md – complete during Async Unit 3 (config + JPA custom query). Upload to Skillable as the async lab Instructions.

Prerequisites

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

Quick start

./mvnw spring-boot:run

Complete the configuration, repository query, JdbcTemplate count, and transactional method as described in the Skillable instructions.

Pushing to Git

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

Lab alignment

• Module: JSE Module 6 – Building APIs in Java
• Unit: 3 – Connecting to Databases
• This repo (async only): Config with env vars, JPA custom query (e.g. findByPriceLessThan). Precursor to the workshop demo.
• Workshop lab: Separate repo lab-03-connecting-databases-workshop – starter has async completed; learners add JdbcTemplate and transaction documentation.