Spring H2 Support: Difference between revisions

From NovaOrdis Knowledge Base
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

Playground Spring Data H2 JPA

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:

Spring Data JPA - 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 Data JPA Database Initialization
spring.jpa.generate-ddl=true

Alternative:

spring.datasource.initialization-mode=always
spring.jpa.hibernate.ddl-auto=none
spring.jpa.show-sql=true

SpringBoot DevTools H2 Console

SpringBoot DevTools H2 Console