Embedded Database support
auto-configure support
H2
HSQL
Derby
Simply include a build dependency
Example
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.hsqldb</groupId>
<artifactId>hsqldb</artifactId>
<scope>runtime</scope>
</dependency>
Connection URLs
Not required
If you do config, ensure db's automatic shutdown is disabled
H2: DB_CLOSE_ON_EXIT=FALSE
In jHipster
jdbc:h2:file:./target/h2db/db/my-app;DB_CLOSE_DELAY=-1
HSQLDB: shutdown=true is NOT used
DBs
H2
In-Memory
One connection per db
jdbc:h2:mem:
Opening two connections within the same JVM means opening two dbs.
Multiple connections per db
jdbc:h2:mem:db-name
Accessing the same database only works within the same VM and class loader
Access from another process
jdbc:h2:tcp://localhost/mem:db-name
Closing
By default, closing the last connection to a db closes the db.
adding ';DB_CLOSE_DELAY=-1' to the URL keeps the db alive as long as the JVM is alive.
File
URL: 'jdbc:h2:[file:][<path>]<database-name>'
'file:' is optional
Closing
adding ';DB_CLOSE_DELAY=-1' to the URL keeps the db alive as long as the JVM is alive.
adding ';DB_CLOSE_ON_EXIT=FALSE' to disable db closing on JVM exiting.
This is RECOMMENDED in spring-boot tutorials
Compatibility
compatibility modes
DB2, Derby, HSQLDB, MSSQL, MySQL, Oracle
Integration test
an empty maven project
HSQLDB (server mode)
java -cp ../lib/hsqldb.jar org.hsqldb.server.Server --database.0 file:sandboxDb --dbname.0 sandboxDb
java -cp .;../lib/hsqldb.jar org.hsqldb.util.DatabaseManager -user sa -url jdbc:hsqldb:database/sandboxDb
integrate with liquibase-maven-plugin
#liquibase.properties
driver: org.hsqldb.jdbc.JDBCDriver
url: jdbc:hsqldb:hsql://localhost/sandboxDb
username: SA
password:
org.hsqldb:hsqldb:2.2.8
org.liquibase:liquibase-core:2.0.5
org.liquibase:liquibase-maven-plugin:2.0.5
liquibase.properties
db.changelog.xml
database schema/data deployment
spring orm / hibernate / transactional annotation
test with in-memory db
