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