
Spring Data JPA를 공부 중 dto에 데이터를 주입하는 select 쿼리를 작성하였다.
@Query("SELECT a, b FROM Clm002 a LEFT JOIN Clm002f b on a.climbSn = b.climbSn AND a.grade = b.grade AND a.sn = b.sn WHERE a.climbSn = :climbSn")
List<ClimbGrade> selectClimbGradeList(@Param(value = "climbSn") Long climbSn);
실행 시 No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQueryTupleBackedMap] to type [com.example.climb.dto.ClimbGrade] 오류 발생
dto를 @Query에 사용할 때에는 명시가 필요
@Query("SELECT NEW com.example.climb.dto.ClimbGrade(a.climbSn, a.grade, a.sn, a.note, a.inptDt, b.orgnFileNm, b.filePath)"
+ "FROM Clm002 a LEFT JOIN Clm002f b on a.climbSn = b.climbSn AND a.grade = b.grade AND a.sn = b.sn WHERE a.climbSn = :climbSn")
List<ClimbGrade> selectClimbGradeList(@Param(value = "climbSn") Long climbSn);