ObjectDB Database Search

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria. Join Type Parameters: - the source type of the join - the target type of the join Super Interfaces: From , Path , FetchParent , Expression , Selection , TupleElement A join to an entity, embeddable, or basic type. Since: Jakarta

, a full iteration over the Cartesian product is avoided. [INNER] JOIN As discussed above, range ... an additional type of identification variable, a join variable, which represent a more limited iteration over specified collections of objects. The following query uses one range variable and one join

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From Join join (    SingularAttribute attribute ,    JoinType jt ) Create a join to the specified single-valued attribute using the given join type. Parameters: jt - join type attribute - target of the join

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From Join join (    String attributeName ,    JoinType jt ) Create a join to the specified attribute using the given join type. Parameters: attributeName - name of the attribute for the target of the join jt

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Join treat (    Join join ,    Class type ) Downcast Join object to the specified type. Parameters: join - Join object type - type to be downcast to Returns: Join object of the specified type. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Join correlate (    Join parentJoin ) Create a subquery join object correlated to a join object of the enclosing query. Parameters: parentJoin - join object of the containing query Returns: subquery join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From Join join (    EntityType entity ,    JoinType joinType ) Create and add a join to the given entity. Parameters: entity - metamodel entity representing the join target joinType - join type Returns: the resulting join . Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From SetJoin join (    SetAttribute set ,    JoinType jt ) Create a join to the specified Set -valued attribute using the given join type. Parameters: jt - join type set - target of the join Returns: the resulting join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From ListJoin join (    ListAttribute list ,    JoinType jt ) Create a join to the specified List -valued attribute using the given join type. Parameters: jt - join type list - target of the join Returns: the resulting join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From MapJoin join (    MapAttribute map ,    JoinType jt ) Create a join to the specified Map -valued attribute using the given join type. Parameters: jt - join type map - target of the join Returns: the resulting join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From CollectionJoin join (    CollectionAttribute collection ,    JoinType jt ) Create a join to the specified Collection -valued attribute using the given join type. Parameters: jt - join type collection - target

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Join Join on (    Expression restriction ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any. Parameters: restriction

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Join Join on (    Predicate... restrictions ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any. Parameters: restrictions

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From Join join (    SingularAttribute attribute ) Create an inner join to the specified single-valued attribute. Parameters: attribute - target of the join Returns: the resulting join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From Join join (    Class entityClass ,    JoinType joinType ) Create and add a join to the given entity. Parameters: entityClass - the target entity class joinType - join type Returns: the resulting join . Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From Join join (    EntityType entity ) Create and add an inner join to the given entity. Parameters: entity - metamodel entity representing the join target Returns: the resulting join . Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From Join join (    String attributeName ) Create an inner join to the specified attribute. Parameters: attributeName - name of the attribute for the target of the join Returns: the resulting join . Throws

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From CollectionJoin join (    CollectionAttribute collection ) Create an inner join to the specified Collection -valued attribute. Parameters: collection - target of the join Returns: the resulting join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From Join join (    Class entityClass ) Create and add an inner join to the given entity. Parameters: entityClass - the target entity class Returns: the resulting join . Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From SetJoin join (    SetAttribute set ) Create an inner join to the specified Set -valued attribute. Parameters: set - target of the join Returns: the resulting join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From ListJoin join (    ListAttribute list ) Create an inner join to the specified List -valued attribute. Parameters: list - target of the join Returns: the resulting join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From MapJoin join (    MapAttribute map ) Create an inner join to the specified Map -valued attribute. Parameters: map - target of the join Returns: the resulting join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Join Attribute getAttribute() Return the metamodel attribute representing the join target, if any, or null if the target of the join is an entity type. Returns: metamodel attribute or null. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Join From getParent() Return the parent of the join . Returns: join parent. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Join JoinType getJoinType() Return the join type. Returns: join type. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Join Predicate getOn() Return the predicate that corresponds to the ON restriction(s) on the join , or null if no ON condition has been specified. Returns: the ON restriction predicate. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Enum Constant in jakarta.persistence.InheritanceType JOINED A table for each abstract or concrete entity class, with only the columns mapped to persistent fields ... instance might be stored across multiple table rows. A join is used to retrieve the state of such entities. Since: Jakarta Persistence (JPA) 1.0

: - the source type - the element type of the collection - the collection type Super Interfaces: Join ... functionality that is common to joins to all collection types. It is not intended to be used directly in ... ) Create a fetch join to the specified single-valued attribute using an inner join . Inherited from

: - the source type of the join - the type of the target Map value - the type of the target Map key Super Interfaces: PluralJoin , Join , From , Path , FetchParent , Expression , Selection , TupleElement The MapJoin interface is the type of the result of joining to a collection over an association or element

: - the source type of the join - the element type of the target Set Super Interfaces: PluralJoin , Join ... of the result of joining to a collection over an association or element collection ... a fetch join to the specified single-valued attribute using an inner join . Inherited from

: - the source type of the join - the element type of the target Collection Super Interfaces: PluralJoin , Join , From , Path , FetchParent , Expression , Selection , TupleElement The CollectionJoin interface is the type of the result of joining to a collection over an association or element collection

: - the source type of the join - the element type of the target List Super Interfaces: PluralJoin , Join ... of the result of joining to a collection over an association or element collection ... ) Create a fetch join to the specified single-valued attribute using an inner join . Inherited from

, but may also be an embeddable belonging to an entity in the from clause. Serves as a factory for Join s of associations ... join to the specified single-valued attribute using an inner join . Inherited from FetchParent Parameters: attribute - target of the join Returns: the resulting fetch join . Since: Jakarta Persistence (JPA

fetch ( SingularAttribute attribute ) Create a fetch join to the specified single-valued attribute using an inner join . Inherited from FetchParent Parameters: attribute - target of the join Returns: the resulting fetch join . Since: Jakarta Persistence (JPA) 1.0 Fetch fetch ( SingularAttribute

the equivalent JOIN query. Entity Type Expressions The TYPE operator (which is new in JPA 2) returns the type ... its subinterfaces ( From , Root , Join and Join 's descendants). Path Expressions The Root and Join interfaces ... Variable Paths: Root country = query. from (Country.class); Join neighborCountry = country. join

( composite ) indices. Collection and array elements are indexable (extremely fast JOIN queries ... optimizations. Configurable JPA eager/lazy fetch  and JPA query FETCH JOIN . Configurable JDO fetch ... , max) - for paging. Query Structure SELECT (including NEW ). FROM (including INNER JOIN , LEFT OUTER

variables (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 examples. Join Fetch Elements Join Fetch is managed in criteria queries by the following interfaces

: - the source type of the fetch - the target type of the fetch Super Interfaces: FetchParent Represents a join ... fetch ( SingularAttribute attribute ) Create a fetch join to the specified single-valued attribute using an inner join . Inherited from FetchParent Parameters: attribute - target of the join Returns

( SingularAttribute attribute ) Create a fetch join to the specified single-valued attribute using an inner join . Parameters: attribute - target of the join Returns: the resulting fetch join . Since: Jakarta Persistence (JPA) 1.0 Fetch fetch ( SingularAttribute attribute , JoinType jt ) Create a fetch join

of the containing query Returns: subquery root. Since: Jakarta Persistence (JPA) 1.0 Join correlate ( Join parentJoin ) Create a subquery join object correlated to a join object of the enclosing query. Parameters: parentJoin - join object of the containing query Returns: subquery join . Since: Jakarta

: Annotation Target: Method, Field Specifies a column for joining an entity association or element collection. If the JoinColumn annotation itself is defaulted, a single join column is assumed ... Customer class @OneToMany @JoinColumn(name = "CUST_ID") // join column is in the table for Order

key join column is in the collection table, join table, or table of the target entity that is used to represent the map. If no MapKeyJoinColumn annotation is specified, a single join column is assumed ... upon the context. If the join is for a map key for an element collection, the foreign key column is in

manager is joined to an active transaction, the persistence context remains managed ... if invoked on an entity manager which has not been joined to the current transaction and a lock mode ... if invoked on an entity manager which has not been joined to the current transaction and a lock mode

Persistence (JPA) 1.0 Join treat ( Join join , Class type ) Downcast Join object to the specified type. Parameters: join - Join object type - type to be downcast to Returns: Join object of the specified type. Since: Jakarta Persistence (JPA) 2.1 CollectionJoin treat ( CollectionJoin join , Class type

in the results directly, but their content can be added to the SELECT clause by using a bound JOIN

, multiselect , array , tuple , construct ). Criteria FROM  ( from , join , fetch ). Criteria WHERE  

elements (representing range variables, join and fetch): Other criteria query expressions (for all the query clauses):

to the structure of SELECT queries. DELETE queries cannot include multiple variables and JOIN

that ability and require multiple tables, multiple records and join operations in order to support

: SELECT c, l FROM Country c JOIN c.languages l WHERE c.population :p AND l in :languages The FROM clause