using h2 as standalone embedded code example
Example: H2 enabling remote database creation first
//Try this in your application.properties. It worked for me:
spring.datasource.url=jdbc:h2:~/test
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect