31 | 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 class ... Invoice i LEFT OUTER JOIN i.itemList items"); List resultList = query.getResultList |
31 | Detaching objects after JOIN FETCHHi, 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 |
31 | "Problem" with cross join=InheritanceType.JOINED) ... @ManyToOne private CI ci; subclass CIstring private String text; I ... primary key fields in JOIN queries). Please try the new build (2.0.4_01) that should fix the bug |
30 | joining of tablesHi In objectdb site i found :Note: This ORM/SQL annotation is silently ignored by ObjectDB so i want join tow table and generate a third table. Ex: table 1: employee table 2: address and the generate table will be table 3: emp_add employee: e_id, e_name address: add_id, city, house |
30 | Query execution time issue Entity e inner join e.person person inner join person.address address left join address.place addressPlace left join address.city addressCity left join address.county addressCounty left join person.birthPlace birthPlace left join person.birthCounty birthCounty left join person |
6 | 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 |
6 | 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 |
6 | Index Definition JOIN queries: SELECT d FROM Document d JOIN d.words w WHERE w = 'JPA' The Document entity class ... can also be used for executing the following query: SELECT d FROM Document d JOIN d.words w |
6 | Mapped by fields are not initialized by JOIN FETCH in queriesAs demonstrated in this forum thread, a mapped by collection field with lazy fetch mode is not initialized in results of a query that uses JOIN FETCH on that collection field (when enhancement is used). support Support Build 2.4.1_06 fixes this issue (fields are now initialized and the test in |
0 | [ODB1] Chapter 7 - JDOQL Queries as a replacement for the JOIN operation of SQL Support of bound variables is mandatory, but support ... by ObjectDB, but considered optional by JDO. Queries with unbound variables are similar to JOIN ... like JOIN queries in SQL, queries with unbound variables may become very slow, so caution is needed |
