Home » Search

About JOIN

41-50 of 200Refresh
JDO Doc
48

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
47

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
47

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
47

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
47

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
47

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
45

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
45

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
28

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
25

ObjectDB Object Database Features

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