86 | InternalError on multiple AND and JOIN QueryHi, 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.valueAsString='Los Angeles')) AND (($6.name='areacode |
86 | Lazy Init / Eager / Join Fetch collection strategy ? What to choose ?,join fetch seems to be the right choice. What about ObjectDb ? The implementation is totally different. Is an "All eager strategy" more efficient that many join fetch ( cartesian product + distinct ... all strategy" Or "Fetch Join strategy" for ObjectDb ? Regards, Xirt xirt Sylvain > Is an "All eager |
86 | Possible issue for JPQL "LEFT [OUTER] JOIN"Possible issue for JPQL "LEFT [OUTER] JOIN" is doing "[INNER] JOIN". Thanks. eurojet P. F. Martinez ... A a LEFT OUTER JOIN a.listB b WHERE b IS NULL" where the output would be [A4, null] or even throw ... FROM A a LEFT OUTER JOIN a.listB b WHERE b.id IS NULL" but it works fine with an relationship |
85 | How to use JOIN FETCH? JOIN FETCH to avoid excessive round trips to the database: SELECT c FROM Country c JOIN FETCH c ... . TypedQuery<Person> q = em.createQuery( "select p from Person p join fetch p.addressHistory ... duplication then this is normal for JOIN FETCH and you can remove duplication by using SELECT DISTINCT |
85 | Multiple joins did not return expected result a specific calendar by its id 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 Unfortunately ... FROM Calendar c1, SharedCalendar c2 INNER JOIN c1.events AS event1 INNER JOIN c2.original.events |
84 | Join performance in Objectdb fields in Page and Image are not annotated with @Id or @Index. In that case, executing the JOIN ... a JOIN on ID fields, similarly to your original query. The second query uses JOIN on direct |
84 | Join query problem with new statetment when using query with join. The query code is: TypedQuery<InspirationsPerSupplierResult> inspirationQuery ... ) from Inspiration insp join insp.products p where (p.supplier = ?1 ... InspirationsPerSupplierResult(insp, p) from Inspiration insp join insp.products p where (p.supplier |
17 | javax.persistence.criteria.Subquery root Since: JPA 2.0 Join<X,Y> correlate( Join<X,Y> parentJoin) Create a subquery join object correlated to a join object of the enclosing query. Create a subquery join object correlated to a join object of the enclosing query. Parameters: parentJoin - join object of the containing query Returns |
16 | Problem with JOIN and inheritance.customer.VendorCustomer $1 JOIN $1.qubletFRAGMENTMAP $2, com.quasado.foundation.warehouse.contract ... I do select from "VendorCustomer" yet through using the join, he is also selecting all "Customer ... should not even join the $1.qubletFRAGMENTMAP of any other class but "VendorCustomer"!? thanks Alex quasado |
16 | Issue with full cross joinshi, There seems to be an issue with full cross joins & maps. This query: SELECT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.qubletFRAGMENTMAP $4 ... It seems that simple iteration on map values in JOIN has not been implemented and a map was handled as a collection |
