Internal Website Search
71-80 of 200 resultsRefreshHow do I achieve a Deep Fetch using JOIN FETCH?"> SELECT c FROM C JOIN FETCH c.bList WHERE c.id=:id But when I attempt to take it to the 2nd level: SELECT c FROM C JOIN FETCH c.bList JOIN FETCH c.bList.aList ... -query"> SELECT c FROM C JOIN c.bList b JOIN FETCH c.bList JOIN FETCH b.aList WHERE c.id=:id | |
LazyInitialization / join fetch_ , especialid4_.descricao descrica2_2_3_ from the User usuario0_ left outer join on area area1_ usuario0_.codigo_area = area1_.codigo left outer join on User usuario2_ usuario0_.codigo_chefe = usuario2_.codigo left outer join company empresa3_ on usuario2_.codigo_empresa = empresa3_.codigo left outer | |
Issue with Casting / Joins().put("test", new EmbeddedA); ... // Try to query using join From<MyEntity> from = criteria.from(MyEntity.class); MapJoin<?,?,?> join = from.joinMap("embeddeds"); Path<?> pathToEmbeddedAName = join.value().get("name") <-- fails with attribute "name" not found | |
Lazy Init / Eager / Join Fetch collection strategy ? What to choose ?/how-to-use-jpa-correctly-to-avoid-complaints-of-a-slow-application/ In this article,join fetch ... different. Is an "All eager strategy" more efficient that many join fetch ( cartesian product ... collection to fetch of each object ! So ... "Eager fetch all strategy" Or "Fetch Join | |
InternalError on multiple AND and JOIN Query Hi, Using objectdb 2.2.8_06. Running the following query: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.contactDetails $2 JOIN $2.addresses $3 JOIN $3.attributeList $4 JOIN $2.phoneNumbers $5 JOIN $5.attributeList $6 WHERE ((($4.name='suburb') AND ($4 | |
How to use JOIN FETCH?/java/jpa/query/jpql/from) gives an example of using JOIN FETCH to avoid excessive round trips to the database: SELECT c FROM Country c JOIN FETCH c.capital join fetch p.addressHistory",Person.class); List<Person> results = q.getResultList | |
Join query problem with new statetment and got nasty exception when using query with join. The query code is: join insp.products p where (p.supplier = ?1)", ... ) from Inspiration insp join insp.products p where (p.supplier = ?1 | |
Join performance in Objectdb. In that case, executing the JOIN may require iteration over 160,000 x 160,000 x 160,000 ... milliseconds (160000) The first query uses a JOIN on ID fields, similarly to your original query. The second query uses JOIN on direct references. The second form is simpler, faster | |
javax.persistence.criteria.Subquery_7410" class="member method"> Join" title="Interface in javax.persistence.criteria">Join<X,Y> Join_" title="Method of javax.persistence.criteria | |
Problem using "and" for joined entities and indexed fields join p.children c where c.age = 42", Parent.class).getResultList().size()); System.out.println(em.createQuery("select from Parent p join p.children c ... ; System.out.println(em.createQuery("select from Parent p join p.children c where c.age |