[Spring Boot Error] nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Table ARTICLE not found; SQL statement



When i try the spring boot, i can see this error. This error makes we cannot initializate our data.

Caused by: org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of URL [file:/Users/Programming/firstProject/build/resources/main/data.sql]: INSERT INTO article(id, title, content) VALUES (1, “aaaa”, “1111”); nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Table “ARTICLE” not found; SQL statement:

You have to do use below code on application.properties. If you add spring.jpa.defer-datasource-initialization=true on application.properties, you’ll not meet your problem.

# application.properties
spring.jpa.defer-datasource-initialization=true