Spring H2 Support: Difference between revisions
Jump to navigation
Jump to search
Line 32: | Line 32: | ||
To configure IntelliJ IDEA to access the in-memory database see [[IntelliJ_IDEA_H2_Support|IntelliJ IDEA H2 Support]]. | To configure IntelliJ IDEA to access the in-memory database see [[IntelliJ_IDEA_H2_Support|IntelliJ IDEA H2 Support]]. | ||
= | =<span id='Spring_Configuration'></span>Database Access Configuration= | ||
Add in [[application.properties]] or equivalent: | Add in [[application.properties]] or equivalent: | ||
Line 41: | Line 41: | ||
spring.datasource.password= | spring.datasource.password= | ||
spring.datasource.platform=h2 | spring.datasource.platform=h2 | ||
</syntaxhighlight> | |||
=Database Initialization= | |||
<syntaxhighlight lang='text'> | |||
spring.datasource.initialization-mode=always | spring.datasource.initialization-mode=always | ||
spring.jpa.hibernate.ddl-auto=none | spring.jpa.hibernate.ddl-auto=none |
Revision as of 18:17, 31 October 2018
Internal
Playground Example
Overview
Simple Project
Use Spring Initializr to bootstrap the project. Alternatively use Spring Initializr-generated build.gradle and settings.gradle.
To bootstrap JPA and H2, add the following dependencies:
dependencies {
...
implementation('org.springframework.boot:spring-boot-starter-data-jpa')
runtimeOnly('com.h2database:h2')
...
}
Follow the JPA programming model described at Adding Persistence with Spring Data JPA.
To test from command line, add command-line support as specified in Console (command-line) Application with Spring Boot.
To configure IntelliJ IDEA to access the in-memory database see IntelliJ IDEA H2 Support.
Database Access Configuration
Add in application.properties or equivalent:
spring.datasource.url=jdbc:h2:tcp://localhost/mem:default
spring.datasource.username=sa
spring.datasource.password=
spring.datasource.platform=h2
Database Initialization
spring.datasource.initialization-mode=always
spring.jpa.hibernate.ddl-auto=none
spring.jpa.show-sql=true