Jul 10, 2019 · I was experiencing the same issue and I tried every answer listed in the posts. What I believe is the main issue is that I was lacking a spring-boot-starter-jdbc.. .
Web. Web. Web. Web. Web. 1 Answer Sorted by: 1 The main problem is probably "movie" as table-name incl the " So this should work schema.sql: DROP TABLE IF EXISTS movie; CREATE TABLE movie AS SELECT * FROM CSVREAD ('classpath:movie.csv'); here is a working basic example: example on github Note for the example schema.sql for initialization of the DB howto.data-initialization. Web. org.hibernate.tool.schema.spi.commandacceptanceexception: error executing ddl via jdbc statement at org.hibernate.tool.schema.internal.exec.generationtargettodatabase.accept (generationtargettodatabase.java:67) ~ [hibernate-core-5.2.17.final.jar:5.2.17.final] at org.hibernate.tool.schema.internal.schemacreatorimpl.applysqlstring.
Solution 1. You need to just change. spring.jpa.hibernate.ddl-auto property to update or create. and. spring.jpa.properties.hibernate.dialect to org.hibernate.dialect.MySQL5InnoDBDialect (as suggested by Patel Romil ) and everything will work fine.. The create-drop is generally used for testing purpose, when you want to create a table on application startup, perform some db transactions in.