로딩
요청 처리 중입니다...

[native query]union 과 Pagealbe 쓸 때, "could not extract ResultSet; SQL [n/a]; nested exception is org

 [native query]union 과 Pagealbe 쓸 때, "could not extract ResultSet; SQL [n/a]; nested exception is org

다음과 같은 에러 발생시 "could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet" 해결방법 @Query(nativeQuery = true, value = "(select * from 조건문) union (select * from 조건문) ", countQuery = "(select * from 조건문) union (select * from 조건문) ", Page searchDynamicConditionAndUsePageable(Pageable pageable); value와 동일하게 countQuery 을 채워서 추가해 주면 해결...

# could # union # sqlGrammerException # sql # resultSet # query # not # nested # nativequery # native # is # hibernate # extract # exception # countQuery # value