Level « Fetch « JPA Q&A





1. Retrieve all Foo from Hibernate second level cache without a query cache?    stackoverflow.com

In his excellent blog post "Hibernate query cache considered harmful?" Alex Miller (of Terracotta Inc.) explains why using the query cache can be harmful to latency and scalability. My question ...

2. Hibernate Second-Level Query Cache not working Eager Fetching    stackoverflow.com

In NHibernate Profiler I observed that when I use eager fetching on an association, using "left join fetch" in an HQL Query or .SetFetchMode() in a Criteria Query the query no ...

3. strange fetch="join" behavior combined with 2nd level cache    forum.hibernate.org

2009-11-05 15:08:07,093 DEBUG [main] util.SQLStatementLogger (SQLStatementLogger.java:111) - select order0_.id as id1_1_, order0_.color as color1_1_, order0_.cost as cost1_1_, order0_.person_id as person4_1_1_, person1_.id as id0_0_, person1_.name as name0_0_, person1_.age as age0_0_ from orders order0_ inner join person person1_ on order0_.person_id=person1_.id where order0_.id=? 2009-11-05 15:08:07,093 DEBUG [main] cache.EhCache (EhCache.java:74) - key: playground.model.Person#1 1 -> foo

4. Column-level lazy fetching    forum.hibernate.org

From the release notes ... snip= This is a checkbox feature that Hibernate needs for marketing purposes. Any property may be marked lazy="true", and will be fetched from the database when the field is first accessed. This feature requires build-time bytecode instrumentation using an Ant task. If Hibernate encounters uninstrumented classes at runtime, the feature will be transparently disabled. =snip Is ...

5. problem w/ multi-level left fetch joins    forum.hibernate.org

i've got a typical many-to-many modeled as two one-to-many's. in this case, the sample shows the old favorite "students to courses" with an associative entity linking the two containing a grade attribute. my issue has to do with an eager fetch on student by last name intended to gather the associative entities and corrosponding course entities in an eager fetch. the ...

6. Three-level association won't eager fetch    forum.hibernate.org

I have a three-level set of associations: A GolfCourse has many Teesets, and each Teeset has many Ratings. I'd like to be able to join the Ratings to the Teesets during fetch, but I can't get it to happen. Setting the fetch to subselect works fine, but setting it to join seems to do the same thing as select (the default). ...

7. Level fetching on same table.    forum.hibernate.org

Hibernate version:3.0 Name and version of the database you are using:MySQL Hi All, I am playing with the Category example from Hibernate in Action where a Category has sub categories etc. Could someone suggest a way to detect the level (depth) of a Category in the tree? For example CategoryA has Category B has Category C, I would like to be ...

8. 3-level (1->2->3) HQL eager fetching    forum.hibernate.org

9. Too slow fetching objects from second-level cache    forum.hibernate.org

Hi, We are using hibernate 3.0.5 in our production enviornment. We have set the transaction timeout in the application to be 5 minutes. In the production logs we see many transaction timeout errors while fetching the master data which is cached in second-level cache. We used Jprofiler to findout the hotspots where the application is spending lot of time. We found ...





10. Hibernate Fetching Strategies Affects On Second Level Cache    forum.hibernate.org

Hello and thanks for taking the time to read my question. I wanted to be able to dynamically setup the collection fetch style (select/join) at runtime but I see I can't do that yet. As an alternative I was thinking of using a reasonable Batch Fetching to help some of that problem. http://docs.jboss.org/hibernate/stable/core/reference/en/html/performance.html#performance-fetching-batch My question is: If I set a default ...