Dear hibernate community, I am trying to translate the query below to criteria api. SELECT er from ereturn er JOIN FETCH product_item pi ON pi.ereturn_id = er.id WHERE pi.status = "RECEIVED" To something like this: CriteriaBuilder builder = em.getCriteriaBuilder(); CriteriaQuery<Ereturn> criter…

Just cast the productItemFetch to a Join and then use the productItemJoin to get the attribute. CriteriaBuilder builder = em.getCriteriaBuilder(); CriteriaQuery<Ereturn> criteria = builder.createQuery( Ereturn.class ); Root<Ereturn> er = criteria.from(Ereturn.class); Fetch<Ereturn, ProductItem> p…

Dear @vlad , I have updated my question, I hope it is more clear now thank you very much

Just remove the productItemJoin and use the productItemFetch instead. CriteriaBuilder builder = em.getCriteriaBuilder(); CriteriaQuery<Ereturn> criteria = builder.createQuery( Ereturn.class ); Root<Ereturn> er = criteria.from(Ereturn.class); Fetch<Ereturn, ProductItem> productItemFetch = er.fetch…

I changed code to predicates.add(builder.equal( productItemFetch.get( "status" ), "RECEIVED")); but compiler complains: The method get(String) is undefined for the type Fetch<Ereturn,ProductItem> I also tried casting from Fetch to Join like Join<Ereturn, ProductItem> productItemFetch = (Join<Ere…

How can I do a JOIN FETCH in criteria api

Hibernate ORM

vlad May 27, 2018, 11:20am 2

You didn’t tell if there is something not working with your example.

Did you try that example and it didn’t work?

Topic		Replies	Views
Can Fetch be used as parameter of treat() for downcasting? Hibernate ORM	1	1756	November 29, 2019
Cast fetch to join : error Hibernate ORM	0	774	April 5, 2019
Why does Hibernate Criteria generate a JOIN clause when using FetchType.EAGER Hibernate ORM	3	4279	December 24, 2018
Join clause in Criteria API left out with versions 6.5.0.Final and above Hibernate ORM	8	973	October 11, 2024
JPA Criteria Join Fetch several tables Hibernate ORM	1	5447	November 3, 2022

How can I do a JOIN FETCH in criteria api

Related topics