About join

61-70 of 200Refresh
Forum
23

Detaching objects after JOIN FETCH

Hi, I have a question about detaching objects after issuing query with JOIN FETCH. Let's say I ... to fetch all B classes with all A classes skipping lazy loading: select b from B b join fetch b ... is closed, B.aClasses is always null. I thought, that after join fetch and CascadeType.DETACH list
Issue
23

Issue with full cross joins

hi, 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 ... values in JOIN has not been implemented and a map was handled as a collection of the first half
Forum
23

Join performance in Objectdb

annotated with @Id or @Index. In that case, executing the JOIN may require iteration over 160,000 x ... . Query 2 completed in 109 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
Forum
23

Join query problem with new statetment

when using query with join. The query code is: TypedQuery inspirationQuery ... ) from Inspiration insp join insp.products p where (p.supplier = ?1 ... ) from Inspiration insp join insp.products p where (p.supplier = ?1
Forum
23

LEFT (OUTER) JOIN problem when mappedBy is defined

this query: "SELECT i FROM Invoice i LEFT OUTER JOIN i.itemList items" But this query never returns ... JOIN works correctly. Is this normal behaviour? Thank you Michael   Sample application public ... Invoice i LEFT OUTER JOIN i.itemList items"); List resultList = query.getResultList
Issue
23

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 My bad, 2.4.0 seems to fix it. quasado
Forum
23

"Problem" with cross join

=InheritanceType.JOINED) ... @ManyToOne private CI ci; subclass CIstring private String text; I ... fields in JOIN queries). Please try the new build (2.0.4_01) that should fix the bug. The attached test
Result
23

ObjectDB Object Database Features [2018-01-27]

elements are indexable (extremely fast JOIN queries). Map keys and values are indexable. Nested paths ... query FETCH JOIN. Configurable JDO fetch groups. Ease of Use and Learning ObjectDB is very simple ... (including INNER JOIN, LEFT OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL expressions
Result
23

ObjectDB Object Database Features [2018-10-27]

elements are indexable (extremely fast JOIN queries). Map keys and values are indexable. Nested paths ... query FETCH JOIN. Configurable JDO fetch groups. Ease of Use and Learning ObjectDB is very simple ... (including INNER JOIN, LEFT OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL expressions
Result
23

ObjectDB Object Database Features

(extremely fast JOIN queries). Map keys and values are indexable. Nested paths inside embedded objects ... Automatic pre-loading optimizations. Configurable JPA eager/lazy fetch and JPA query FETCH JOIN ... (first, max) - for paging. Query Structure SELECT (including NEW). FROM (including INNER JOIN, LEFT