Hibernate join fetch

Question

I have implemented the following example in this blog https://www.tutorialandexample.com/hibernate-n-1-select-problem/ but I am not happy with the output that I am getting. I am displaying the output which shows Department details and Employee details printed as twice . I want to get the Department details and Employee details to be displayed only once . Any Suggestions ?

The size of depart List object is 4 but actually it must be 2 .

output :

Department details::::: 20 IT Employees details:::::: 21 jyotika 22 shubham Department details::::: 20 IT Employees details:::::: 21 jyotika 22 shubham Department details::::: 23 Accounts Employees details:::::: 24 nihal 25 neha Department details::::: 23 Accounts Employees details:::::: 24 nihal 25 neha

Please read How to Ask and minimal reproducible example and then modify your question. — Lukas Novicky
– Lukas Novicky, Commented Feb 13, 2020 at 9:19

Vishnu Atrai · Accepted Answer · 2020-02-13 09:24:22Z

Provide result transformer Criteria.DISTINCT_ROOT_ENTITY in query

List depart= sess.createQuery("From Department", Department.class).setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).getResultList();

Collectives™ on Stack Overflow

Hibernate join fetch

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related