인프런 커뮤니티 질문&답변

강의를 따라하다가 아래와 같은 에러가 나며 종료가 되었는데 테이블명 USER 대신 USERS 로 변경하니 정상동작 했습니다.

다른분들 참고하세요.

Spring Boot 2.7.0 버전 입니다.

 

java.lang.IllegalStateException: Failed to execute ApplicationRunner

at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:765) ~[spring-boot-2.7.0.jar:2.7.0]

at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:752) ~[spring-boot-2.7.0.jar:2.7.0]

at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.7.0.jar:2.7.0]

at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) ~[spring-boot-2.7.0.jar:2.7.0]

at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295) ~[spring-boot-2.7.0.jar:2.7.0]

at com.example.db.DbApplication.main(DbApplication.java:10) ~[classes/:na]

Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE [*]USER(id INTEGER NOT NULL, name VARCHAR(255), PRIMARY KEY (id));"; expected "identifier"; SQL statement:

CREATE TABLE USER(id INTEGER NOT NULL, name VARCHAR(255), PRIMARY KEY (id)); [42001-212]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:502) ~[h2-2.1.212.jar:2.1.212]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:477) ~[h2-2.1.212.jar:2.1.212]