H2 Skill

Configures and troubleshoots the H2 in-memory database used for development and testing in this Spring Boot 3 project. H2 runs embedded within the JVM, requires no external database process, and resets on every restart via create-drop DDL. The H2 web console is available at http://localhost:8080/h2-console (JDBC URL: jdbc:h2:mem:itemdb).

Quick Start

Start the server and open the console:

mvn spring-boot:run
# then navigate to http://localhost:8080/h2-console
# JDBC URL: jdbc:h2:mem:itemdb  |  user: sa  |  password: (blank)

Key properties in src/main/resources/application.properties: