Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Fully Working Prototypes With Spring Boot and H2

DZone's Guide to

Fully Working Prototypes With Spring Boot and H2

In-memory databases are great for unit tests, but they can also help with prototyping! We take a look at how to do just that using Spring Boot and H2.

· Java Zone ·
Free Resource

Atomist automates your software deliver experience. It's how modern teams deliver modern software.

We use a lot of H2 with Spring, especially for unit tests. However, instead of unit tests, we might want to have a fully functional prototype with data to display.

H2 is the perfect candidate for that. It works great with Spring, has strong syntax compatibility with most databases out there, and provides a UI to check your data.

Imagine the scenario of an interview assignment. You want your example to work out of the box, with as little configuration as possible for the reviewer.

The plan is to have the application up and running with data. Before accessing the application, we might as well add data to it. Then, we need to have a proper way to display the data added without adding extra code.

The first step is to go to the Spring initializr and add the Web and H2 dependencies. Also, we shall add the JDBC property.

The end result will give us a build.gradle file like this:

buildscript {
ext {
springBootVersion = '2.0.6.RELEASE'
}
repositories {
mavenCentral()
}
dependencies {
classpath("org.springframework.boot:spring-boot-gradle-plugin:${springBootVersion}")
}
}

apply plugin: 'java'
apply plugin: 'eclipse'
apply plugin: 'org.springframework.boot'
apply plugin: 'io.spring.dependency-management'

group = 'com.gkatzioura.springbooth2'
version = '0.0.1-SNAPSHOT'
sourceCompatibility = 1.8

repositories {
mavenCentral()
}


dependencies {
implementation('org.springframework.boot:spring-boot-starter-jdbc')
implementation('org.springframework.boot:spring-boot-starter-web')
runtimeOnly('com.h2database:h2')
testImplementation('org.springframework.boot:spring-boot-starter-test')
}


Since we added the JDBC property, we can have some schema scripts executed once the application is started.
Thus, we need to create a schema.sql file containing the SQL statements which create the schema.


CREATE TABLE application_user (ID INT, USER_NAME VARCHAR(50), PASSWORD VARCHAR(255));
INSERT INTO application_user (ID,USER_NAME, PASSWORD) values (1,'test','password-hash');


The next step is to enable the H2 console. We will go with the YAML approach; however, you can do it either using a properties file or environmental variables.


spring:
  h2:
    console:
      enabled: true


Now, once we get our Spring application running, we can navigate at the http://localhost:8080/h2-console endpoint.
We shall be presented with the default credentials needed.

Once we have logged in, we can query for the user we had inserted on our startup SQL script.

That's it! This can make wonders for prototypes, interview assignments, and blog posts like this!

Get the open source Atomist Software Delivery Machine and start automating your delivery right there on your own laptop, today!

Topics:
java ,spring boot ,h2 ,in-memory database ,prototyping ,tutorial

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}