Customize spring data jpa repository's query to avoid fetch eager fields

Question

Let's say I have a spring-boot-based project, that uses spring data jpa to define entities and map them to a postgres db.

The entity has some @ManyToOne annotatated "joins" - with eager fetch set. I can not change it. Part of the project relies on this eagerness.

I want to be able to write a custom @Query("...") in my entity's repository such as I can explicitly - for this specific query - avoid the eagerness.

Is there a syntax to achieve it?

keep in mind that the end goal is to be able to update a field for all retrieved values

Carlos Jafet Neto · Accepted Answer · 2025-11-25 17:33:09Z

You can use EntityGraph annotation before your Query to define a query's fetch plan. If you define an empty attribute paths for it you are basic saying to don't fetch anything, otherwise you can specify the attributes to eagerly fetch:

// No eager fetching @EntityGraph(attributePaths = {}) @Query(...) // Eager fetch products @EntityGraph(attributePaths = {"products"}) @Query(...)

unfortunately I cannot use this pattern because of github.com/spring-projects/spring-data-jpa/issues/3682
The fix for #3682 was released with Spring Boot 3.4.1. Are you saying you're not allowed to upgrade Spring Boot?

Collectives™ on Stack Overflow

Customize spring data jpa repository's query to avoid fetch eager fields

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related