Published on

Integrate an H2 Database in Your Spring Boot App

Authors

原文地址 https://dzone.com/articles/integrate-h2-database-in-your-spring-boot-applicat

In this tutorial, we will be integrating the H2 database in your Spring Boot application. Note that the H2 database is in the embedded mode.

You have created a Spring Boot application and would like to integrate with an H2 database.

In pom.xml, add the below dependency:

<!-- H2 Database -->
 <dependency>
 <groupId>com.h2database</groupId>
 <artifactId>h2</artifactId>
 </dependency>

In the application.properties file, add the below line to enable the H2 database:

# H2
spring.h2.console.enabled=true
spring.h2.console.path=/h2
# Datasource
spring.datasource.url=jdbc:h2:file:~/test
spring.datasource.username=sa
spring.datasource.password=
spring.datasource.driver-class-name=org.h2.Driver
Take a Maven build and run the application as a Spring Boot app.

Open a browser and type http://localhost:8080/h2 to get the below image.

The yellow highlighted lines should match your application.properties file.

That's it! If you get stuck, kindly comment below.