Home » Search

About join

51-60 of 200Refresh
JPA Doc
23

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
JPA Doc
21

javax.persistence.criteria.FetchParent

, Join, ListJoin, MapJoin, PluralJoin, Root, SetJoin Represents an element of the from clause ... 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
20

JPQL JOIN FETCH Error

Hello I get an error when executing the following JPQL query: select doi from Doi doi left join fetch doi.metadata metadata left join fetch metadata.titles titles left join fetch metadata.creators creators left join fetch metadata.descriptions descriptions left join fetch metadata
JPA Doc
19

javax.persistence.criteria.Subquery

root Since: JPA 2.0 Join correlate( Join 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
Forum
19

Left join fetch behaviour doesn't retrieve children?

Hello, I'm a little bit confused about a left join fetch behaviour. In this test case, i try to fetch my 3 children using a left join fetch. But my collection is null after closing the em ... left join fetch         em = emf.createEntityManager();         TypedQuery query
Manual
18

Index Definition

above, the index order should be x first and y second. Indexes on collections are useful in JOIN queries: SELECT d FROM Document d JOIN d.words w WHERE w = 'JPA' The Document entity class contains a words ... for executing the following query: SELECT d FROM Document d JOIN d.words w WHERE LENGTH(w) >= 10
Forum
17

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
17

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
16

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
16

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