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 | @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 |
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 |
9 | TypedQuery implementation problems, at.debitSign, at.creditSign, at.reportTypeId)" + " from Account acct" + " left outer join AccountTransaction att on acct.id = att.accountId" + " left outer join Transaction trans on att.transactionId = trans.id" + " left outer join AccountGroup ag on acct.accountGroupId = ag.id |
8 | Cast in typed query: SELECT o FROM OtherType o JOIN o.types t WHERE t instanceof MySpecificType But how can I cast ... JOIN o.types t WHERE t instanceof MySpecificType AND t.value = :value itsme Martin Petzold The solution is a Java-like cast: SELECT o FROM OtherType o JOIN o.types t WHERE t instanceof MySpecificType AND ((MySpecificType)t).value = :value itsme Martin Petzold |
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 | [ObjectDB 2.5.5_03] Unexpected exception (Error 990) FROM Unit t INNER JOIN t.lastGeocodedPosition l WHERE l IS NULL OR l.receiveTime < :last ... LEFT OUTER JOIN t.lastGeocodedPosition l WHERE l.receiveTime < :last See also this paragraph in ... work but I modified it a little bit and now it does: SELECT t FROM Unit t LEFT OUTER JOIN t |
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 |
