spring.sql.init.schema-locations Not Working

user_2013472 0
Viewed 1487

I'm using profiles to determine which data connector to use (dev=h2, prod=mySQL). I'm attempting to use

spring.sql.init.schema-locations=

To set the location to the relevant path with properties from the active profile but I keep getting:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: 
Invocation of init method failed; nested exception is java.lang.IllegalStateException: No schema scripts found at location './database/h2/schema-h2.sql'
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804) ~[spring-beans-5.3.15.jar:5.3.15]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) ~[spring-beans-5.3.15.jar:5.3.15]

and the same error no matter where I point the property to.

Is there any other special syntax for declaring which file or which directory under resources for this property? When I edit this property autocomplete in Idea happily shows the folder/file structure, but Spring can't see what I'm pointing to!

spring-data-jpa spring-boot schema sql
1 Answers

Answer as per @Andy Wilkinson's comment above:

Adding classpath: as a prefix resolved the issue.

user_20134720
Related