About INNER JOIN

111-120 of 200Refresh
JPA Doc
3

MapKeyJoinColumn.name

of the foreign key column for the map key. The table in which it is found depends upon the context. If the join ... for the map value. If the join is for a map key for a ManyToMany entity relationship or for a OneToMany entity relationship using a join table, the foreign key column is in a join table. If the join
Forum
3

OR not working with isNull

to something such as: SELECT e FROM MyEntity e JOIN e.owner o WHERE o IS NULL OR o.id = :userId Notice that the navigation root.get("owner").get("id") is implemented as INNER JOIN. This is a requirement of the JPA specification, which is known to cause some confusion. You have to use LEFT OUTER JOIN explicitly to cover entities with a null owner. bhamilton
JPA Doc
3

fetch(attribute, jt)

Method javax.persistence.criteria.FetchParent Fetch fetch(   PluralAttribute attribute,   JoinType jt ) Create a fetch join to the specified collection-valued attribute using the given join type. Parameters: attribute - target of the join jt - join type Returns: the resulting join Since: JPA 2.0
JPA Doc
3

fetch(attribute, jt)

Method javax.persistence.criteria.FetchParent Fetch fetch(   SingularAttribute attribute,   JoinType jt ) Create a fetch join to the specified single-valued attribute using the given join type. Parameters: attribute - target of the join jt - join type Returns: the resulting fetch join Since: JPA 2.0
JPA Doc
3

fetch(attributeName, jt)

 jt ) Create a fetch join to the specified attribute using the given join type. Parameters: attributeName - name of the attribute for the target of the join jt - join type Returns: the resulting fetch join Throws: IllegalArgumentException - if attribute of the given name does not exist Since: JPA 2.0
JPA Doc
3

javax.persistence.PessimisticLockScope

that are contained in join tables will be locked if the javax.persistence.lock.scope property is specified ... , element collections and relationships owned by the entity that are contained in join tables ... only the rows in the join table or collection table for that relationship or collection. This means
JPA Doc
3

joinCollection(attributeName, jt)

,   JoinType jt ) Create a join to the specified Collection-valued attribute using the given join type. Parameters: attributeName - name of the attribute for the target of the join jt - join type Returns: the resulting join Throws: IllegalArgumentException - if attribute of the given name does not exist Since: JPA 2.0
JPA Doc
3

joinList(attributeName, jt)

 jt ) Create a join to the specified List-valued attribute using the given join type. Parameters: attributeName - name of the attribute for the target of the join jt - join type Returns: the resulting join Throws: IllegalArgumentException - if attribute of the given name does not exist Since: JPA 2.0
JPA Doc
3

joinMap(attributeName, jt)

 jt ) Create a join to the specified Map-valued attribute using the given join type. Parameters: attributeName - name of the attribute for the target of the join jt - join type Returns: the resulting join Throws: IllegalArgumentException - if attribute of the given name does not exist Since: JPA 2.0
JPA Doc
3

joinSet(attributeName, jt)

Method javax.persistence.criteria.From SetJoin joinSet(   String attributeName,   JoinType jt ) Create a join to the specified Set-valued attribute using the given join type. Parameters: attributeName - name of the attribute for the target of the join jt - join type Returns: the resulting join