use h2 database in file

h2.md

# config/application.yml

spring:
    application:
        name: deliverybundler
    datasource:
        type: com.zaxxer.hikari.HikariDataSource
        url: jdbc:h2:file:./build/h2db/deliverybundler;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;MULTI_THREADED=FALSE
        name:
        username: sa
        password: secret
        hikari:
            auto-commit: false

# to keep the database
    jpa:
        hibernate:
            ddl-auto: create

To keep the populated data during test

@Test
@Rollback(value = false)
public void testSort() {}

h2.png