About INNER JOIN

101-110 of 200Refresh
Issue
4

[ObjectDB 2.5.5_03] Unexpected exception (Error 990)

because it implicitly defines an INNER JOIN, i.e. an internal loop, and if the the internal loop is empty ... that according to the JPA specification, your query is equivalent to: SELECT t FROM Unit t INNER JOIN t.lastGeocodedPosition l WHERE l IS NULL OR l.receiveTime < :last and since there is no t
JPA Doc
4

JoinColumn.name

column. The table in which it is found depends upon the context. If the join is for a OneToOne or ... of the source entity or embeddable. If the join is for a unidirectional OneToMany mapping using a foreign key mapping strategy, the foreign key is in the table of the target entity. If the join
JPA Doc
4

javax.persistence.AssociationOverride

, the joinColumns element is used. If the relationship mapping uses a join table, the joinTable element must be specified to override the mapping of the join table and/or its join columns. Example 1: Overriding ... See Also: Embedded Embeddable MappedSuperclass AttributeOverride JoinColumn[] joinColumns The join
JPA Doc
4

javax.persistence.JoinTable

the mapping of associations. It is specified on the owning side of an association. A join table ... -to-one relationships, and one-to-one associations (both bidirectional and unidirectional). When a join table ... of the join table is assumed to be the table names of the associated primary tables concatenated
Forum
3

No clue how to query with collection

null). So I want something like this: SELECT c, a FROM Customer INNER JOIN c.addresses ORDER BY ... from the collection with a WHERE clause BUT in this query: SELECT c, a FROM Customer INNER JOIN c ... Customer LEFT JOIN c.addresses a WHERE a IS NULL OR a.active = TRUE ORDER BY a.street If it doesn't
Forum
3

slow performance for a complex query

queries. Some nested queries are actually equivalent to JOIN. When the inner query is not dependent ... you noticed the execution of this query involves nested loops of full scan of Organisation. The inner loop is executed about 100M times. In cases with complex AND/OR structures like this, sometimes JOIN
Forum
3

@OneToOne query issue with OR and IS NULL

through a relationship is implemented using JOIN (i.e. INNER JOIN), and only the A instance that has another passes the FROM clause, which precedes the WHERE clause. Try LEFT OUTER JOIN: SELECT a FROM A a LEFT JOIN ... is a short form of the this equivalent query: SELECT a FROM A a JOIN a.another b
JPA Doc
3

MapKeyJoinColumn.table

that contains the foreign key column. If the join is for a map key for an element collection, the foreign key column is in the collection table 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
JPA Doc
3

correlate(parentJoin)

Method javax.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: JPA 2.0
JPA Doc
3

JoinColumn.table

of the applicable entity. Default: If the join is for a OneToOne or ManyToOne mapping using a foreign key mapping strategy, the name of the table of the source entity or embeddable. If the join ... of the target entity. If the join is for a ManyToMany mapping or for a OneToOne or bidirectional