About JOIN

191-200 of 200Refresh
Forum
2

ODB IndexActivation NullPointerException

(e.g. by using join). We run still into a dead lock. I adding a few screenshots and I hope it help ... ]  ->  waiting for  Thread id:427  (ODB-IndexActivation)   the Thread.join() was called by ObjectDB ... ;     } } if (indexActivationThread != null) {     try {         indexActivationThread.join();     } catch (InterruptedException
Forum
2

@OneToOne query issue with OR and IS NULL

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 a FROM A a LEFT JOIN
Forum
2

com.objectdb.o.NLV cannot be cast to com.objectdb.o.RSV

Hello! 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
Issue
2

[ObjectDB 2.5.5_03] Unexpected exception (Error 990)

JOIN t.lastGeocodedPosition l WHERE l IS NULL OR l.receiveTime < :last and since there is no t.lastGeocodedPosition there are no results. Maybe you should try: SELECT t FROM Unit t LEFT OUTER JOIN ... bit and now it does: SELECT t FROM Unit t LEFT OUTER JOIN t.lastGeocodedPosition l WHERE l
Forum
1

How to query for list of lists ?

directly in the SELECT clause. But this should work: SELECT f FROM Inspiration i JOIN i ... PulseDataWareHouse w JOIN w.reviewSnippets s I don't get an error but instead only the get the first entry String ... You cannot select a list, so this is an invalid JPQL query. SELECT s FROM PulseDataWareHouse w JOIN w
Issue
1

Internal Exception

(DISTINCT $1) FROM com.lexware.vereinsverwaltung.abrechnung.beitrag.BeitragForderung $1 LEFT JOIN $1.currency $2 LEFT JOIN $1.paymentTerm $3 LEFT JOIN $1.receiver $4 WHERE ((((($2 IS NOT NULL) AND (UPPER($2
Forum
1

Mapped By Fetch is very Slow

in my application is more due to that problem than the left join one. ( Note : The left join index ... automatic query: SELECT $$owner, $$inv FROM MyEntityChild $$owner JOIN $$owner.myEntity $$inv
Forum
1

No clue how to query with collection

null). So I want something like this: SELECT c, a FROM Customer INNER JOIN c.addresses ORDER BY ... from the collection with a WHERE clause BUT in this query: SELECT c, a FROM Customer INNER JOIN c ... Customer LEFT JOIN c.addresses a WHERE a IS NULL OR a.active = TRUE ORDER BY a.street If it doesn't
Forum
1

significant performance decrease

query is: select o from ObjectNode o join o.childNodes c where o.classIdentifier = '(CU ... with queries that embed parameters as strings: SELECT o FROM ObjectNode o JOIN o.childNodes c WHERE o ... ') AND       o.type = 0 It is better to use parameters: SELECT o FROM ObjectNode o JOIN o.childNodes c
Forum
1

slow performance for a complex query

is executed about 100M times. In cases with complex AND/OR structures like this, sometimes JOIN ... queries. Some nested queries are actually equivalent to JOIN. When the inner query is not dependent on the outer query - no JOIN is required. But such nested query (if possible in your case