javaspringspring-bootspring-data-jpaprojection

Does spring data jpa @query support projection?

spring boot version: 1.5.10, spring data jpa 1.11.10

In my MyEntityRespostory:

 Page<MyEntityPro> findByName(String name,Pageable pageable ) // working

 @("select e from MyEntity e")
 Page<MyEntity> search1(Pageable pageable) // working

 @("select e from MyEntity e")
 Page<MyEntityPro> search2(Pageable pageable) //error-No aliases found in result tuple! Make sure your query defines aliase

I searched the error and found: issue DATAJPA-885

Solution

  • If you use upper query keyword, it will cause the problem.

    ....
@query("SELECT e FROM MyEntity") // bug
......
@query("select e from MyEntity") // working
...