depth « Fetch « JPA Q&A





1. depth of outer join fetch    forum.hibernate.org

I believe that outer join fetches only get go to a depth of one. That is if class A has a set of class B and class B has a set of type C then I can get all of A's set B using an outer join but I won't be able to get all the B's sets C using an ...

2. Fetch depth    forum.hibernate.org

3. hibernate.max_fetch_depth    forum.hibernate.org

I have a question about Hibernate's max_fetch_depth property. My understanding of the property is that it will limit the number of tables that Hibernate will query in an outer join. So, for example, if I have: table CUSTOMER { CUSTOMER_ID, CUSTOMER NAME, CUSTOMER_COUNTY_ID (references COUNTY_ID) } table COUNTY { COUNTY_ID, COUNTY_NAME, COUNTY_STATE_ID (references STATE_ID) } table STATE { STATE_ID, STATE_NAME } ...

4. max_fetch_depth confusion    forum.hibernate.org

"Maximum fetched Graph depth" is not necessarily the same as "maximum number of outer joins". If fetching 3 objects deep, you may still get more than 3 outer joins, for example if you have joined-subclass mappings. 3 is a sensible default, because if you fetch deeper, the fetched result sets get really large ...

5. How does max_fetch_depth affect PropertyAccessExceptions?    forum.hibernate.org

Hi, I am having some bad luck trying to figure out how and why I will get PropertyAccess Exceptions on differnet occasions, and on different configurations. On our setup we have a small cluster of machines running an app built on top of SpringFramework. We just took TreeCacheProvider into production and witnessed strange problems, getting null pointer exceptions in places where ...

6. About the fetch depth    forum.hibernate.org

Suppose both the association from Category to Item and from Item to Bid are one-to-many. I declare outer-join="true" for both associations and load a single Category. I think Hibernate should execute only one query, but it do two. Then, I think the problem lies in the global fetch depth. Thoug I set the global fetch depth to 4, the result is ...

7. Fetch Depth    forum.hibernate.org

[b]Mapping documents:[/b] ... ... Whe I get one Person select pers from Person where pers.subjectId=:sid I get an: No row with the given identifier exists: 2528, of class: EmailAddress because that person doesn't have an email address. ...

8. Question about fetch depth    forum.hibernate.org

I have an HQL query that I'm doing a join fetch to get an association, but how do I go deeper down the chain of associations in one query? Since HQL ignores the mapping "join" settings, can I somehow specify fetch depth in the query? BTW, I'm using HQL because I'm using "distinct" and found this to be the easiest way. ...





10. General question about fetch depth and eager fetching.    forum.hibernate.org

This is just a general question about hibernate capability. If one had a series of objects with the following relationship scenerio: A has many to one to B which has a many to one to C which has many to one to D which has many to one to E and the fetching for all these associations is set to eager ...