Spring H2 Support: Difference between revisions
Jump to navigation
Jump to search
Line 33: | Line 33: | ||
=<span id='Spring_Configuration'></span>Database Access Configuration= | =<span id='Spring_Configuration'></span>Database Access Configuration= | ||
Based on: {{Internal|Spring_Data_JPA#Database_Access_Configuration|Spring Data JPA - Database Access Configuration}} | |||
Add in [[application.properties]] or equivalent: | Add in [[application.properties]] or equivalent: |
Revision as of 19:09, 3 December 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
Based on:
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.jpa.generate-ddl=true
Alternative:
spring.datasource.initialization-mode=always
spring.jpa.hibernate.ddl-auto=none
spring.jpa.show-sql=true