Why is there the ability to use lazy="false" and fetch="select" in the mapping, but not in the Criteria API.

For example, if I have lazy="proxy" and fetch="select", why can't I call criteria.setLazy on the association so that it will behave exactly as if I had lazy="false" and fetch="select", but just for that Criteria?

Criteria.setFetchMode does not help me. I do not want to do a join fetch. I want it to do a select fetch. I just want to change "WHEN" it is loaded, not "HOW".

Let me try asking this a different way ...

How can I eagerly fetch an association using "select" fetching if the association mapping is configure as lazy="true"? It appears that doing a "join" fetch is my only option in either the Criteria or Query API.

You can do a fetch join. That ignore the lezy setting.


Farzad-

I want to do the fetch in a separate select; I don't want to do a sql join. That is the whole point. I have several collections that need to be fetched. If I join them all, I end with the Cartesian Product problem. I have found doing separate selects to much more performant.