Important Notes

Using Dialects for sql lite with the below configurations in your application.properties may not be suitable for mocking and testing,

this is because such in memory (sql lite) databases DO NOT support retrieval of AUTO-INCREMENTED and AUTO-GENERATED ids persisted to sqlite databases.

spring.datasource.url=jdbc:sqlite:classpath:datastore.db

spring.datasource.driverClassName=org.sqlite.JDBC

spring.jpa.database-platform=org.hibernate.community.dialect.SQLiteDialect

spring.datasource.initialization-mode=always

spring.jpa.hibernate.ddl-auto=update

Directory Map.