Displaying an H2 in-memory database on the web with Spring Boot

Displaying an H2 in-memory database on the web with Spring Boot

Since it is troublesome to build a RDB, the H2 database is in-memory, so it is very convenient because it can be used out of the box with only dependencies.

If you place schema.sql under “src/main/resources/”, you can create tables in advance.

If data.sql is placed under “src/main/resources/”, data can be created in advance.

Add the following two dependencies to build.gradle.

developmentOnly 'org.springframework.boot:spring-boot-devtools'
runtimeOnly 'com.h2database:h2'

Next, add a setting to application.yml.

spring:
  datasource:
    url: jdbc:h2:mem:testdb # In this case, I used a schema called testdb.
    driverClassName: org.h2.Driver

  h2:
    console:
      enabled: true
      path: /h2-console

This will launch the Spring Boot application.

After launching, access “http://localhost:8080/h2-console/” and you will see the following screen.

Press “Connect” to see the screen as shown below.

This screen also allows for operations such as Select and Insert statements.

高橋