Internal Website Search
161-170 of 200 resultsRefreshhow 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 b.name = ?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 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.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 o.properties p1 where o ... > locating ObjectNode (v$1) instances that satisfy: (o.linkedObjects join v$1). (o.properties 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 o.properties p1 join o.linkedObjects c1 where o.classIdentifier = '(OP)' and (((c1.classIdentifier ... ' and p1.doubleValue > 0) select distinct o from ObjectNode o join o | |
getModel()> metamodel type representing the Set that is the target of the join | |
JoinType.RIGHT outer join. Since: JPA 2.0 | |
JoinTable.inverseJoinColumns="description"> (Optional) The foreign key columns of the join table which reference the primary |