Spring数据JPQL联接查询中的计数抛出IllegalArgumentException

Question

@Query(value = "select distinct a from EntityA as a left join fetch a.listEntityB as b where ...")
  public List<EntityA > find....(@Param("") String value, Pageable pageable);

@Query(value = "select count(distinct a) from EntityA as a left join fetch a.listEntityB as b where ...) 
  public long count...(@Param("") String value);

Answer 1

将CountQuery放在与查询本身相同的注释中。所以

@Query(value = "select ...", countQuery = "select count..")
public List<EntityA > find....(@Param("") String value, Pageable pageable);

还要从CountQuery中删除“fetch”。

要获得记录总数，只需引用页。gettotalElements()来返回记录总数。