About join

41-50 of 200Refresh
JDO Doc
54

Join.uniqueKey

Annotation Element javax.jdo.annotations.Join String uniqueKey The name of the unique key constraint to generate. Returns: the name of the unique key constraint Default value: "" Since: JDO 2.1
JPA Doc
50

javax.persistence.criteria.CollectionJoin

>, FetchParent, From, Join, Path, PluralJoin,E>, Selection, TupleElement The CollectionJoin interface is the type of the result of joining to a collection ...  attributeName) Create a fetch join to the specified attribute using an inner join. Create a fetch join
JPA Doc
50

javax.persistence.criteria.ListJoin

>, From, Join, Path, PluralJoin,E>, Selection, TupleElement The ListJoin 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
50

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
50

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
50

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
49

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
48

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
31

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

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