About JOIN

51-60 of 200Refresh
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
JPA Doc
22

javax.persistence.criteria.Fetch

javax.persistence.criteria Interface Fetch Superinterfaces: FetchParent Represents a join ... a fetch join to the specified attribute using an inner join. Create a fetch join to the specified attribute using an inner join. Parameters: attributeName - name of the attribute for the target
Forum
22

LEFT JOIN FETCH over empty embedded collection returns no results

First of all, thank you for promptly implementing JOIN FETCH over nested paths in response ... , but I attempt to LEFT JOIN FETCH all the members of a collection within a (non-existent) member ... where bList is empty, the following works (returns my instance of C): SELECT c FROM C c LEFT JOIN
Forum
21

multiple LEFT JOINs do not work as expected

like this: SELECT DISTINCT $1 FROM Organisation $1 JOIN $1.attributeList $2 LEFT JOIN $1.parentOrg $3 LEFT JOIN $3.parentOrg $4 WHERE ((($2.name='Attribute1') AND ($2 ... , since I use LEFT Joins this query should return all organisation under the root organisation
Forum
21

How do I achieve a Deep Fetch using JOIN FETCH?

know that I can express one level of eager fetch in JPQL as follows: 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 WHERE c.id=:id I get an error along the lines of: Invalid fetch path
Forum
21

LazyInitialization / join fetch

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 join on specialty especialid4
Forum
21

Query with FETCH JOIN returns multiple results instead of one.

jpqlResult = em.createQuery( "SELECT d FROM Demand d JOIN FETCH d.services WHERE d=:demand ... with DISTINCT: SELECT DISTINCT d FROM Demand d JOIN FETCH d.services WHERE d=:demand You are probably ... Department d LEFT JOIN FETCH d.employees WHERE d.deptno = 1 "A fetch join has the same join semantics
Forum
21

Issue with Casting / Joins

MyEntity(); entity.getEmbeddeds().put("test", new EmbeddedA); ... // Try to query using join From from = criteria.from(MyEntity.class); MapJoin join = from.joinMap("embeddeds"); Path pathToEmbeddedAName = join.value().get("name") <-- fails with attribute "name" not found
JPA Doc
21

Criteria Query From Elements

(bound by an entity class) are represented by the Root subinterface: Join variables (bound by an attribute of a preceding variable in the FROM clause) are represented by the Join subinterface and its descendant interfaces: See the FROM in Criteria Queries section for more details and examples. Join