I have a class that I am querying where I have a single projection that is an association. I am attempting to also eagerly fetch that association and its related properties, however Hibernate always returns the projected properties as lazy. Anyone have any idea how to do this?

I found this thread that looks to be the same issue: viewtopic.php?f=1&t=1003446&start=0

Thanks!

Try to elaborate it with some code examples because it's not clear what you are asking.

That will be slightly difficult since I am using Hibernate through another abstraction layer, however

UserRole is a class with a composite key of types User and Role
User has a ToOne to itself

Hibernate Criteria is deprecated, so it's no longer supported.

Try with an HQL or JPA Criteria example instead.

Vlad,

The example provided there isn't even my actual code. The idea was just to give you an example of what I'm trying to do. HQL is not an option for me since some of the code to create the query is dynamic. I'm not familiar with the JPA criteria API, so unfortunately at this time I can't provide you can example with that either.

Thanks for your time

The reason why I mentioned it is because, even if there's a bug, it will not be fixed anyway.

More, this is not strictly a projection, it's just fetching of an association which you can do with JPQL as follows:



That's it.

Vlad,

Thanks for the response and I understand what you mean.

In this case I want User objects to be returned, not UserRole objects.

I was able to work around the issue by query directly to User and using a sub select to ensure the user is in the list