14 | query hint: SELECT DISTINCT o from ObjectNode o join o.properties p1 join o.properties p2 join o.properties p3 join o.properties p4 where o.classIdentifier = '(OP)' and o.linkedObjects.classIdentifier = '(TC ... <ObjectNode>(); the query is: SELECT DISTINCT o from ObjectNode o join o.properties p1 join o.properties p2 |
13 | Performance issues on aggregate query) from ObjectNode o INNER JOIN o.properties p1 INNER JOIN o.properties p2 INNER JOIN o.properties p3 INNER JOIN o.properties p4 INNER JOIN o.properties p5 INNER JOIN o.properties p6 INNER JOIN o.properties p7 join o.linkedObjects c1 where o.classIdentifier = '(OP)' and (o.linkedObjects |
12 | Problem with distinct select, order by and equivalent alias/attribute path distinct s_location " + "from Street s " + "left join s.location as s_location ... " + "left join s.location as s_location " + "order by s.location.id asc ... " + "from Street s " + "left join s.location as s_location " + "order by |
11 | ODB IndexActivation NullPointerException embedded mode and delay closing the database until its completion (e.g. by using join). support ... (ODB-IndexActivation) the Thread.join() was called by ObjectDB. The [pool-5-thread-3] is our thread ... != null) { try { indexActivationThread.join(); } catch (InterruptedException e |
10 | com.objectdb.o.NLV cannot be cast to com.objectdb.o.RSVHello! This query is working fine SELECT DISTINCT $1 FROM ChatHistoryItem $1 JOIN $1.recipient $2 JOIN $1.sender $3 WHERE ($2.id='22afeafe-363f-4397-8553-cc5688ba142d') OR ($3.id='22afeafe ... ChatHistoryItem $1 JOIN $1.recipient $2 WHERE ($2.id='22afeafe-363f-4397-8553-cc5688ba142d') ORDER BY MAX |
10 | @OneToOne query issue with OR and IS NULL another.counter = 0 is a short form of the this equivalent query: SELECT a FROM A a JOIN a.another b ... through a relationship is implemented using JOIN (i.e. INNER JOIN), and only the A instance that has another passes the FROM clause, which precedes the WHERE clause. Try LEFT OUTER JOIN: SELECT |
2 | javax.persistence.criteria.AbstractQuery entities (which may in turn own joins). All queries may have: a conjunction of restrictions |
2 | Strange Error with Criteria API and Sorting; import javax.persistence.criteria.Join; import javax.persistence.criteria.Root; public class ... .createQuery(TestEntity.class); Root<TestEntity> root = query.from(TestEntity.class); final Join<?, ?> otherJoin = root.join("other"); query.orderBy(cb.asc(cb.upper((Expression<String |
2 | Multiple MEMBER OF query OF is implemented using JOIN with a new synthetic variable for iteration over the collection. In ... due to the conversion to JOIN). However, using separate variables may sometimes make the query more complex ... . As a quick solution, you may replace AND of MEMBER OF with 2 explicit JOIN variables for iteration |
1 | Unexpected query token - AS, artifact FROM com.btc.ep.engine.bl.internal.dmos.EngineInstanceImpl AS instance JOIN instance ... artifact LEFT JOIN artifact.activatedGoals AS artifactActivatedGoals LEFT JOIN artifact.activatedAssumptions AS artifactActivatedAssumptions LEFT JOIN artifact.activatedCalibrations AS |
