[ERROR] Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: {VO class name} near line 1, column 249

error log

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: {VO class name} near line 1, column 249 [query문]

 

오류 코드

@Query("SELECT v.studentId AS studentId, v.studentName AS studentName, SUM(v.mathScore) AS mathScore, "
        +"SUM(v.engScore) AS engScore, v.className AS className, v.grade AS grade"
        +"FROM StudentVo v WHERE v.insertDate BETWEEN ?1 AND ?2 GROUP BY v.studentId, v.studentName, v.className, v.grade")

JPA를 사용한 Repository에서 나타난 오류이다

딱봐도 구문이 틀린 오류인데 쿼리문을 봤을때는 이상이 없어서 사실 249번까지 세었는데 로그에서도 틀린 부분이 확인되었다ㅎ

그렇다 FROM 앞에 띄어쓰기가 안되어서 그런거였다

 

수정코드

@Query("SELECT v.studentId AS studentId, v.studentName AS studentName, SUM(v.mathScore) AS mathScore, "
        +"SUM(v.engScore) AS engScore, v.className AS className, v.grade AS grade "
        +"FROM StudentVo v WHERE v.insertDate BETWEEN ?1 AND ?2 GROUP BY v.studentId, v.studentName, v.className, v.grade")

 

 

결론 : 로그를 잘보자