Internal Website Search

161-170 of 200 resultsRefresh

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

. You have to use JOIN to define a variable that will iterate over the collection elements. join f.bars b where = ?1 More details are provided on the join">FROM page of the ObjectDB manual. support Support

Weird issue with variable naming

it without success, all I can say is that we do a LEFT JOIN on an embedded property as well as ordering ... as well as the name of our left join variable becomes $1. We're also adding a custom function ... .CriteriaBuilder; import javax.persistence.criteria.CriteriaQuery; import javax.persistence.criteria.Join

queries more than 10 times slower using 2.8.1 versus 2.7.6

1: "select o from ObjectNode o join o.linkedObjects l1 where o.classIdentifier = '(SI)' and o ... distinct o from ObjectNode o join p1 join p2 join p10 join p20 join p21 where o.classIdentifier = '(OP)' and (o.linkedObjects

Query Execution Error

.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.mitgliedschaft $2 LEFT JOIN $2.abteilungen $3 LEFT JOIN $3.abteilung $4 WHERE (((NOT ((($2 IS NOT NULL) AND ($3 IS NOT NULL) AND ($4 IS NOT NULL ... .vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.mitgliedschaft $2 LEFT JOIN $2.abteilungen

ClassCastException in Tuple.get

.createTupleQuery(); Root<DemandAnswer> rootDemandAnswer = cq.from(DemandAnswer.class); Join<DemandAnswer, Demand> joinDemand = rootDemandAnswer.join("demand"); Join<Object, Object> joinDemandingPerson = joinDemand.join("demandingPerson"); Join<Object, Object>

queries under 2.7.6_4 significantly slower than under 2.7.6

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

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

Zwicker here are some typical queries:   select o from ObjectNode o join p1 join o.linkedObjects c1 where o.classIdentifier = '(OP)' and (((c1.classIdentifier ... ' and p1.doubleValue > 0)   select distinct o from ObjectNode o join o


> metamodel type representing the Set that is the target of the join


outer join. Since: JPA 2.0


="description"> (Optional) The foreign key columns of the join table which reference the primary