About join

151-160 of 200Refresh
JPA Doc
5

javax.persistence.JoinColumns

See Also: JoinColumn JoinColumn[] value The join columns that map the relationship. The join columns that map the relationship. Since: JPA 1.0
Forum
5

Searching lists within objects

to have the real object at search time. Trying to use join is problematic as for every extra attribute I add to the search, I need to add 2 more joins. Obviously this is not satisfactory ... );         Root cdi = q.from(CDI.class);                 Join attributeJoin = cdi
Issue
4

Issue with DISTINCT Select

.IndividualContact $1 LEFT JOIN $1.profile $2 WHERE ((TYPE($1)=class com.quasado.foundation.contact.api.model ... .contact.individual.IndividualContact $1 LEFT JOIN $1.profile $2 ORDER BY UPPER($1.profile.lastName ... !??   Alex Note: We're using the left join to select all entities, also those which have profile = null
Issue
4

Weird issue with variable naming

is that we do a LEFT JOIN on an embedded property as well as ordering is involved in selection ... of our left join variable becomes $1. We're also adding a custom function expression in where clause ... ; import javax.persistence.criteria.Join; import javax.persistence.criteria.JoinType; import
Issue
4

queries more than 10 times slower using 2.8.1 versus 2.7.6

join o.linkedObjects l1 where o.classIdentifier = '(SI)' and o.type = 0 and o.state = 0 and (o ... 2: "select distinct o from ObjectNode o join o.properties p1 join o.properties p2 join o.properties p10 join o.properties p20 join o.properties p21 where o.classIdentifier = '(OP)' and (o
Issue
4

Query Execution Error

JOIN $1.mitgliedschaft $2 LEFT JOIN $2.abteilungen $3 LEFT JOIN $3.abteilung $4 WHERE (((NOT ((($2 ... .mitglied.Mitglied $1 LEFT JOIN $1.mitgliedschaft $2 LEFT JOIN $2.abteilungen $3 LEFT JOIN $3.abteilung $4 ... DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.mitgliedschaft
Issue
4

ClassCastException in Tuple.get

= cq.from(DemandAnswer.class); Join joinDemand = rootDemandAnswer.join("demand"); Join joinDemandingPerson = joinDemand.join("demandingPerson"); Join joinProvidingPerson = rootDemandAnswer.join("providingPerson"); joinDemand.join
Issue
4

each 1-2 days objects on some objectdb level lock/block each other

:   select o from ObjectNode o join o.properties p1 join o.linkedObjects c1 where o.classIdentifier ... join o.properties p1 join o.properties p2 where (o.classIdentifier = "(OP)" and o.linkedObjects ... .doubleValue = 0)))   select distinct o from ObjectNode o join o.properties p1  join o.linkedObjects c1
Forum
4

how to query by properties of onetomany relations? (Error 990)

JOIN to define a variable that will iterate over the collection elements. This specific query should be rewritten as follows: select f from Foo f join f.bars b where b.name = ?1 More details ... sql joins :) in my last projects i have been using mongodb and such a query was possible for embedded
Issue
4

queries under 2.7.6_4 significantly slower than under 2.7.6

(you have our test db) select distinct o from ObjectNode o join o.properties p1 where o.classIdentifier = "(OP ... .ObjectNode locating ObjectNode (v$1) instances that satisfy:    (o.linkedObjects join v$1). [Step 2b ... $2) instances that satisfy:    (o.properties join v$2). [Step 3b] Evaluate fields in ObjectProperty