Which steps enable SQLite with Spring-Boot and JPA? Which steps enable SQLite with Spring-Boot and JPA? sqlite sqlite

Which steps enable SQLite with Spring-Boot and JPA?


For Hibernate the so called strategy class is a functional implementation of the org.hibernate.dialect.Dialect class. For the most common database there is a short cut and then you can use the database property and simply specify the database (like ORACLE, DB2 etc.). However that doesn't exists for SQLite, you would need to configure the specific dialect.

To specify the dialect you can use the database-platform property and just pass the dialect to use to it.

jpa:    database-platform: that.custom.SQLiteDialect

This also works for any other dialect like the org.hibernate.dialect.MySQL5InnoDBDialect if you want to specify a specific one for MySQL (for instance).