Internal Website Search
101-110 of 200 resultsRefreshLazy 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 | |
Multiple joins did not return expected result like: SELECT event FROM Calendar c1, SharedCalendar c2 INNER JOIN c1.events AS event INNER JOIN c2.original.events AS event WHERE c1.id=?1 OR c2.id=?1 SELECT event1, event2 FROM Calendar c1, SharedCalendar c2 INNER JOIN | |
Group by: list if no aggregate function is specified/from#left_outer_inner_join_fetch">JOIN FETCH for this purpose. support Support ... Hello! In a query like SELECT parent, children FROM Parent parent LEFT JOIN p.children children GROUP BY parent maybe it would be good if it will return a list | |
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 | |
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 | |
Issue with DISTINCT Select FROM com.quasado.foundation.contact.individual.IndividualContact $1 LEFT JOIN $1.profile $2 ... .IndividualContact $1 LEFT JOIN $1.profile $2 ORDER BY UPPER($1.profile.lastName) Alex quasado Alexander Adam Note: We're using the left join | |
Problem with JOIN and inheritance-query"> SELECT DISTINCT $1 FROM com.quasado.serviceplaza.customer.VendorCustomer $1 JOIN $1 ... "VendorCustomer" yet through using the join, he is also selecting all "Customer" classes which fullfill the where requirements. This seems to be clearly wrong to me because I should not even join |