How to use Hibernate to combine efficient queries on @ManyToMany association?

Question

I have 2 entities with a ManyToMany association between them - FeedbackApp & FeedbackAppProfile and each of them has a tenant-id FK to Tenant entity.

FeedbackApp entity:

public class FeedbackApp {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
       
    @ManyToOne
    @JoinColumn(name = "tenant_id")
    private Tenant tenant;

    /*
        Marked as the owner side.
     */
    @ManyToMany(fetch = FetchType.EAGER)
    @JoinTable(name = "feedbackApp_profile_mapping",
            joinColumns = @JoinColumn(name = "feedbackApp_id"),
            inverseJoinColumns = @JoinColumn(name = "profile_id"))
    Set<FeedbackProfile> profiles;
}

The FeedbackProfile entity:

public class FeedbackProfile {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @ManyToOne
    @JoinColumn(name = "tenant_id")
    private Tenant tenant;

    
    @ManyToMany(mappedBy = "profiles", fetch = FetchType.EAGER)
    Set<FeedbackApp> feedbackApps;
}

The feedbackApp_profile_mapping join table has 2 columns and looks like this:

My question: I need to create a query that gets all feedback apps for a specific feedback profile and tenant id. Is it possible to get it with Hibernate/JPA OR I have to manually query my join table?

Answer 1

Thanks to @GabiM direction, I created a join fetch query which did the job for what I needed:

@Query(value = "SELECT f FROM FeedbackApp f JOIN FETCH f.profiles p WHERE p.id = ?1 AND p.tenant.id = ?2")
    Set<FeedbackApp> getFeedbackAppsByProfileId(long profileId, long tenantId);