About join

151-160 of 200Refresh
JPA Doc
4

PrimaryKeyJoinColumn.referencedColumnName

Annotation Element javax.persistence.PrimaryKeyJoinColumn String referencedColumnName (Optional) The name of the primary key column of the table being joined to. Defaults to the same name as the primary key column of the primary table of the superclass (JOINED mapping strategy); the same name as
JDO Doc
4

Value.serialized

Annotation Element javax.jdo.annotations.Value String serialized Whether the value is to be stored serialized (into a single column of a join table). Returns: Whether the value is to be stored serialized (into a join table) Default value: "" Since: JDO 2.1
Forum
4

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
3

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
3

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
3

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
3

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
Forum
3

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
3

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
JDO Doc
3

Element.generateForeignKey

Annotation Element javax.jdo.annotations.Element String generateForeignKey Generate or assume a foreign key constraint exists on the column or columns associated with this join. Specify "true" or "false". Returns: whether to generate or assume a primary key constraint Default value: "" Since: JDO 2.1