org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement

송수용·2022년 6월 6일
0

트러블 슈팅

목록 보기
31/35

에러 내용

org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "select user0.id as id1_1, user0.email as email2_1, user0.password as password3_1, user0.role as role4_1, user0.username as username5_1 from [*]user user0 where user0.username=?"; expected "identifier"; SQL statement:
select user0.id as id1_1, user0.email as email2_1, user0.password as password3_1, user0.role as role4_1, user0.username as username5_1 from user user0 where user0.username=? [42001-212]

내가 한 방법

  1. application.properties
  • spring.h2.console.enabled=true
    spring.datasource.url=jdbc:h2:~/springcoredb;MODE=MySQL;DATABASE_TO_LOWER=TRUE
    spring.datasource.username=sa
    spring.datasour;e.password=
    spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
    spring.jpa.database-platform=org.hibernate.dialect.H2Dialect
profile
#공부중 #협업 #소통중시 #백엔드개발자 #능동적 #워커홀릭 #스파르타코딩 #항해99 #미니튜터 #Nudge #ENTJ #브레인스토밍 #아이디어뱅크

0개의 댓글