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 : stackoverflow.com/questions/50949656/… — Olivier Depriester
– Olivier Depriester, Commented May 3, 2020 at 23:41
Perfect, I didn't know you could pass the entity graph as a parameter! thanks! — Gabriele Muscas
– Gabriele Muscas, Commented May 4, 2020 at 13:32

SSK · Accepted Answer · 2020-05-04 04:03:50Z

4

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 4, 2020 at 4:03

answered May 4, 2020 at 3:53

SSK

3,80610 gold badges39 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Gabriele Muscas Over a year ago

Thank you, your answer has been very useful to me. Thanks!

SSK Over a year ago

You can accept the answer so that others know the same

La Hai Over a year ago

I can't seem to find EntityGraphJpaSpecificationExecutor, where did you get it from?

SSK Over a year ago

@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

sinclairjaza · Accepted Answer · 2023-10-06 07:51:37Z

0

You can create two default methods in your repository with same signature like this:

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

    @EntityGraph(attributePaths = { "roles" })
    default List<Roles> findAllByRoles(Specification sp){
       return findAll(sp);
    }

    @EntityGraph(attributePaths = { "groups" })
    default List<Roles> findAllByGroups(Specification sp){
       return findAll(sp);
    }
}

answered Oct 6, 2023 at 7:51

sinclairjaza

11 silver badge1 bronze badge

Collectives™ on Stack Overflow

Spring Data JPA findAll with different EntityGraph

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related