Spring Data JPA findAll with different EntityGraph

Question

in Spring Data JPA Repository i need to specify multiple methods that do the same thing (eg. findAll) but specifying different @EntityGraph annotation (the goal is to have optimized methods to use in different services).

Es.

@Repository
public interface UserRepository extends JpaSpecificationExecutor<User>, JpaRepository<User, Long> {

@EntityGraph(attributePaths = { "roles" })
findAll[withRoles](Specification sp);

@EntityGraph(attributePaths = { "groups" })
findAll[withGroups](Specification sp);

etc...
}

In Java we can't have same method sign multiple times, so how to manage it?

Is it possible without using JPQL?

Thanks,

Gabriele

You can use an ```EntityGraph``` as a parameter : https://stackoverflow.com/questions/50949656/spring-data-jpa-parametrize-entitygraph-in-crudrepository-interface — Olivier Depriester, May 03 '20 at 23:41
Perfect, I didn't know you could pass the entity graph as a parameter! thanks! — Gabriele Muscas, May 04 '20 at 13:32

SSK · Accepted Answer · 2020-05-04T04:03:50.820

5

You can use EntityGraphJpaSpecificationExecutor to pass different entitygraph based on your method.

@Repository
public interface UserRepository extends JpaSpecificationExecutor<User>, JpaRepository<User, Long>, EntityGraphJpaSpecificationExecutor<User> {

}

In your service class, you can call find all with entity graph.

List<User> users = userRepository.findAll(specification, new NamedEntityGraph(EntityGraphType.FETCH, "graphName"))

Like above, you can use a different entity graph different based on your requirement.

edited May 04 '20 at 04:03

answered May 04 '20 at 03:53

SSK

3,444
6
32
59

Thank you, your answer has been very useful to me. Thanks! – Gabriele Muscas May 04 '20 at 13:33
You can accept the answer so that others know the same – SSK May 04 '20 at 13:55
I can't seem to find `EntityGraphJpaSpecificationExecutor`, where did you get it from? – La Hai Mar 10 '21 at 17:37
1

@La Hai, You need to add dependency for it from `https://mvnrepository.com/artifact/com.cosium.spring.data/spring-data-jpa-entity-graph/2.4.2` – SSK Mar 12 '21 at 01:34

Spring Data JPA findAll with different EntityGraph

1 Answers1