Back-End/Issues

[MySQL] caused by: java.sql.sqlsyntaxerrorexception: you have an error in your sql syntax;

yeonx 2023. 9. 12. 20:19
728x90

ERROR

caused by: java.sql.sqlsyntaxerrorexception: you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'type=myisam' at line 6 at com.mysql.cj.jdbc.exceptions.sqlerror.createsqlexception(sqlerror.java:121) ~[mysql-connector-j-8.0.33.jar!/:8.0.33] at com.mysql.cj.jdbc.exceptions.sqlexceptionsmapping.translateexception(sqlexceptionsmapping.java:122) ~[mysql-connector-j-8.0.33.jar!/:8.0.33] at com.mysql.cj.jdbc.statementimpl.executeinternal(statementimpl.java:763) ~[mysql-connector-j-8.0.33.jar!/:8.0.33] at com.mysql.cj.jdbc.statementimpl.execute(statementimpl.java:648) ~[mysql-connector-j-8.0.33.jar!/:8.0.33] at com.zaxxer.hikari.pool.proxystatement.execute(proxystatement.java:94) ~[hikaricp-4.0.3.jar!/:na] at com.zaxxer.hikari.pool.hikariproxystatement.execute(hikariproxystatement.java) ~[hikaricp-4.0.3.jar!/:na] at com.p6spy.engine.wrapper.statementwrapper.execute(statementwrapper.java:115) ~[p6spy-3.9.0.jar!/:na] at org.hibernate.tool.schema.internal.exec.generationtargettodatabase.accept(generationtargettodatabase.java:54) ~[hibernate-core-5.6.15.final.jar!/:5.6.15.final]

 

해결

jpa:
  database-platform: org.hibernate.dialect.MySQL8Dialect