Query specified join fetching, but the owner of the fetched association was not present in the select list

[shiva]

Vlad, I could do the same to fetch Employee entities as suggested, however, when I do this I see the memory issue as mentioned in this post. Each query fetch will retrieve nearly 20-30K results. As also, I have a requirement where the fetched Employee List will be iterated so that all the child entity objects will in turned be mapped to their respective DTO’s. So I thought I can refine the code so that I can still manage with one DTO.

QueryImpl consuming more memory

What you see there is probably the objects that haven’t been collected by the JVM GC, but the proble might be that you are fetchcing more data than necessary. Try using DTO projections because they are more efficient both on the database and on the client side. More, if you have huge Result Sets but only require 10 entries, better use pagination.