Home » Search

About join

151-160 of 200Refresh
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
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
JPA Doc
3

getModel()

Method javax.persistence.criteria.CollectionJoin CollectionAttribute getModel() Return the metamodel representation for the collection attribute. Returns: metamodel type representing the Collection that is the target of the join Since: JPA 2.0
JPA Doc
3

getModel()

Method javax.persistence.criteria.ListJoin ListAttribute getModel() Return the metamodel representation for the list attribute. Returns: metamodel type representing the List that is the target of the join Since: JPA 2.0
JPA Doc
3

getModel()

Method javax.persistence.criteria.MapJoin MapAttribute getModel() Return the metamodel representation for the map attribute. Returns: metamodel type representing the Map that is the target of the join Since: JPA 2.0