Ctrl+K

Spring Boot 2 H2

Spring Boot 2 H2#

Remember an in-memory database is created/initialized when an application starts up; and destroyed when the application shuts down.

H2 Configuration Options#

Simple configuration#

application.properties

spring.datasource.url=jdbc:h2:mem:testdb
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect

Please note by default, Spring Boot configures the in-memory database connection with the username 'sa' and an empty password ' '.

Configure data persistence#

# temporary data storage
spring.datasource.url = jdbc:h2:mem:testdb
# temporary data storage
spring.datasource.url = jdbc:h2:file:/data/sample
spring.datasource.url = jdbc:h2:file:C:/data/sample (Windows only)

Create schema and insert data on initialization#

  • schema.sql – To initialize the schema ie.create tables and dependencies.

  • data.sql – To insert default data rows.

H2 Console#

Enable H2 console#

application.properties

# Enabling H2 Console
spring.h2.console.enabled=true
# Custom H2 Console URL
spring.h2.console.path=/h2

Accessing H2 console#

  • http://localhost:18090/h2

  • Saved Settings: Generic H2 (Server)

  • JDBC URL: jdbc:h2:file:D:/code/spring-boot2

Other configuration options#

We can enable/disable the database trace logs and we can enable/disable the remote access of H2 console.

# Whether to enable trace output.
spring.h2.console.settings.trace=false
# Whether to enable remote access.
spring.h2.console.settings.web-allow-others=false

References#

Contents