Spring Error querying database. Cause: java.sql.SQLSyntaxErrorException

 

호기롭게 스프링 부트 프로젝트를 실행시켰더니 다음과 같은 어처구니 없는 화면을 만날 때가 있다.

Error querying database. Cause: java.sql.SQLSyntaxErrorException

 

전체 내용은 아래와 같다.

Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a fallback.
Thu Oct 14 02:42:30 KST 2021
There was an unexpected error (type=Internal Server Error, status=500).
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'example.t_board' doesn't exist ### The error may exist in file [C:\Users\takur\Desktop\workspace\eclipse-workspace2\board\bin\main\mapper\sql-board.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT board_idx, title, hit_cnt, created_datetime FROM t_board WHERE deleted_yn = 'N' ORDER BY board_idx DESC ### Cause: java.sql.SQLSyntaxErrorException: Table 'example.t_board' doesn't exist ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'example.t_board' doesn't exist
org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'example.t_board' doesn't exist ### The error may exist in file [C:\Users\takur\Desktop\workspace\eclipse-workspace2\board\bin\main\mapper\sql-board.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT board_idx, title, hit_cnt, created_datetime FROM t_board WHERE deleted_yn = 'N' ORDER BY board_idx DESC ### Cause: java.sql.SQLSyntaxErrorException: Table 'example.t_board' doesn't exist

 

 

말 그대로 존재하지 않는 테이블에 접근해서 생기는 간단한 SQL syntax 오류이다.

 

이번 경우에는 application.properties에 입력한 jdbc-url에서 접근할 db 경로를 재수정해주면 제대로 동작한다.

 

기존에 저 부분이 example로 되어 있었다.

 

유의해서 경로를 지정하도록 하자.