Setting Max Fetch Depth for One Query?

lukasbradley · **Posted:** Mon Apr 04, 2005 7:41 pm

Is it possible to set the Environment max_fetch_depth property for a particular query?

In other words, my default configuration has a depth of 2. However, in one case I would like a depth of 3. Generically, I'd like the depth to remain 2 for all other queries, but different for this one.

Thanks for any help.

emmanuel · **Posted:** Tue Apr 05, 2005 1:32 pm

HQL queries are not influenced by max fetch depth

lukasbradley · **Posted:** Tue Apr 05, 2005 1:42 pm

If not HQL, what does it affect?

What is the purpose of the Query.setFetchSize()? The API states:

Quote:

Set a fetch size for the underlying JDBC query.

Which is a tad confusing to me. What does it do?

emmanuel · **Posted:** Tue Apr 05, 2005 1:50 pm

fetchSize Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed

fetch depth : number of joins used to retrieved the object graph