spring boot 2.0hibernate 5.2 <a href="https://motolies.tistory.com/679" target="_blank">2018/06/27 - [프로그램 자료/Java &amp; Spring] - [hibernate] Convert Page &lt; Object[] &gt; to List &lt; Map &lt; String, Object &gt; &gt;</a> 위 상황에서 repository에 native query를 사용하고 싶어서 찾다봄 <div class="txc-textbox" style="border-style: solid; border-width: 1px; border-color: rgb(254, 254, 184); background-color: rgb(254, 254, 184); padding: 10px;">import java.util.List;import java.util.Optional;&nbsp;import org.springframework.data.domain.Page;import org.springframework.data.domain.Pageable;import org.springframework.data.jpa.repository.Query;import org.springframework.data.repository.PagingAndSortingRepository;import org.springframework.data.repository.query.Param;&nbsp;import model.CustomClass;&nbsp;public interface CustomClassRepository
extends PagingAndSortingRepository&lt;CustomClass, byte[]&gt; {&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; // HQL&nbsp;&nbsp;&nbsp; @Query(value = "select
p" + &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"from table_name as a" + &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "where
a.group.name like %:groupname%"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , countQuery
= "select count(*) " + &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "from
table_name as a" + &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "where
a.group.name like %:groupname%"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp; Page&lt;CustomClass&gt; findByGroupNameLike(@Param("groupname") String
groupname, Pageable pageable);&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; // native&nbsp;&nbsp;&nbsp; // native 쿼리 사용시 pageable 사용방법&nbsp;&nbsp;&nbsp; @Query(value = "select
* " + &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "from
table_name as a " +&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "where id =
:id" +&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;" limit ?#{ #pageable.offset },
?#{#pageable.offset + #pageable.pageSize}"&nbsp;&nbsp;&nbsp; , countQuery
= "select count(*) " + &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "from
table_name" +&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "where id =
:id" &nbsp;&nbsp;&nbsp; , nativeQuery
= true)&nbsp;&nbsp;&nbsp; Page&lt;Object[]&gt; findAllMap(@Param("id") byte[] id, Pageable
pageable);&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }&nbsp;</div>

[hibernate] create query pageable