我在我的代码库中有以下查询:
SELECT p FROM Project p JOIN p.users u WHERE u.login =:login
用户和项目之间存在多对多的关系。一切正常,可以返回用户的项目,但我希望针对每个项目返回相应的用户集。
更新:尝试了mateuszlo建议的以下方法:
SELECT p FROM Project p JOIN FECTH p.users JOIN p.users u WHERE u.login =:login
但是现在我遇到了以下异常:
nested exception is java.lang.IllegalArgumentException: Count query validation failed for method public abstract org.springframework.data.domain.Page com.example.app.repository.ProjectRepository.findAllByUserLogin(java.lang.String,org.springframework.data.domain.Pageable)! org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list