Hi friends,

Here is one Sql Query:-

SqlQuery==>SELECT O.*, P.* FROM ORDERS O, PRODUCT P WHERE O.ORDER_ID=P.ORDER_ID;

And the Hibernate query for it is==>


List orders = session.createCriteria(Order.class)
.setFetchMode(“products”,FetchMode.JOIN)
.list();



Could u plz tell me that whats the first parameter of setFetchMode(). According to one manual which i got, the first parameter is known as String AssociationPath.

But i couldnt understand what does it mean.

Could u plz put more focus on it.

Thanks Alot.
With High Regards
Saurav Jain

Hi intimate2talent,

Represents an association fetching strategy. This is used together with the Criteria API to specify runtime fetching strategies

static FetchMode DEFAULT
Default to the setting configured in the mapping file.
static FetchMode EAGER
Deprecated. use FetchMode.JOIN
static FetchMode JOIN
Fetch using an outer join.
static FetchMode LAZY
Deprecated. use FetchMode.SELECT
static FetchMode SELECT
Fetch eagerly, using a separate select.

I think this would give you more clarity.

"products" is how you mapped the association.