About join

41-50 of 200Refresh
JPA Doc
43

javax.persistence.criteria.MapJoin

>, From, Join, Path, PluralJoin,V>, Selection, TupleElement The MapJoin interface is the type of the result of joining to a collection over an association or element ... a fetch join to the specified attribute using an inner join. Create a fetch join to the specified
JPA Doc
43

javax.persistence.criteria.SetJoin

>, From, Join, Path, PluralJoin,E>, Selection, TupleElement The SetJoin interface is the type of the result of joining to a collection over an association or element ... expression of the given type Since: JPA 2.0 Fetch fetch(String attributeName) Create a fetch join
JPA Doc
43

javax.persistence.criteria.PluralJoin

, From, Join, Path, Selection, TupleElement Subinterfaces: CollectionJoin, ListJoin, MapJoin, SetJoin The PluralJoin interface defines functionality that is common to joins ...  attributeName) Create a fetch join to the specified attribute using an inner join. Create a fetch join
JPA Doc
41

javax.persistence.criteria.From

>, Path, Selection, TupleElement Subinterfaces: CollectionJoin, Join, ListJoin, MapJoin ... , but may also be an embeddable belonging to an entity in the from clause. Serves as a factory for Joins ... Since: JPA 2.0 Fetch fetch(String attributeName) Create a fetch join to the specified attribute using
JPA Doc
41

javax.persistence.criteria.Root

> fetch(String attributeName) Create 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 of the join Returns: the resulting fetch join Throws
Forum
33

Query in JPA2 with LEFT JOIN on INNER JOIN

How write a query in JPA2 with LEFT JOIN on INNER JOIN? select a.description, a.id, p1.description, p2.description,p3.description from action a left join action_profile ap1 on ap1.id_action=a.id inner join profile p1 on ap1.id_profile=p1.id and p1.name='?' left join action_profile ap2 on ap2
Manual
29

Paths and Types in JPQL and Criteria API

. It might be easier to understand exactly how this works by considering the equivalent JOIN query ... , Join and Join's descendants). Path Expressions The Root and Join interfaces (which are subinterfaces ... > country = query.from(Country.class); Join neighborCountry = country.join
Forum
25

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
Forum
24

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
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