에러 메세지
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException:
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement; SQL [select user0_.id as id1_13_, user0_.created_at as created_2_13_, user0_.updated_at as updated_3_13_, user0_.agree as agree4_13_, user0_.email as email5_13_, user0_.intro as intro6_13_, user0_.name as name7_13_, user0_.nickname as nickname8_13_, user0_.password as password9_13_, user0_.phone as phone10_13_, user0_.phone_checked as phone_c11_13_, user0_.photo as photo12_13_, user0_.role as role13_13_, user0_.state as state14_13_, user0_.uid as uid15_13_, user0_.username as usernam16_13_ from users user0_ where user0_.id in ()]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "select user0_.id as id1_13_, user0_.created_at as created_2_13_, user0_.updated_at as updated_3_13_, user0_.agree as agree4_13_, user0_.email as email5_13_, user0_.intro as intro6_13_, user0_.name as name7_13_, user0_.nickname as nickname8_13_, user0_.password as password9_13_, user0_.phone as phone10_13_, user0_.phone_checked as phone_c11_13_, user0_.photo as photo12_13_, user0_.role as role13_13_, user0_.state as state14_13_, user0_.uid as uid15_13_, user0_.username as usernam16_13_ from users user0_ where user0_.id in ([*])"; expected "INTERSECTS (, NOT, EXISTS, UNIQUE, INTERSECTS"; SQL statement:
개별 테스트 진행하면 정상 작동하는데
전체 테스트 진행하면 왜 이 한 녀석만 에러가 날까
해결
갑자기 해결이 됐는데 ... 정확히 어떤 사유로 해결이 되었는 지는 모르겠다.
새로 만들었던 테이블 이름이 recommend_ban_user 였는데 이것을 recommend_banuser 로 고쳤고 ..
그냥 변수 이름들을 이것저것 조금씩 바꾸었고 ...
서버를 껐다 켰다 ..
쿼리도 적었다 지웠다 결국 다시 원점으로 돌아갔는데 ...
그랬다 ... ㅎㅎㅎ ...
신기하게 해결이 됐지만
다음에 똑같은 오류가 발생했을 때 다시 해결해야겠다 ...
