About join

191-200 of 200Refresh
Forum
3

Problem with distinct select, order by and equivalent alias/attribute path

distinct s_location "             + "from Street s "             + "left join s.location as s ... "             + "left join s.location as s_location "             + "order by s.location.id asc ... "             + "from Street s "             + "left join s.location as s_location
Issue
3

Multiple MEMBER OF query

JOIN with a new synthetic variable for iteration over the collection. In your query item.label ... seem unacceptable (although JQPL itself has strange behaviour in some known cases due to the conversion to JOIN ... , you may replace AND of MEMBER OF with 2 explicit JOIN variables for iteration over the collection
Forum
3

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

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
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
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
2

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
2

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
2

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
2

New Index causing troubles

) java.lang.Thread.join(Thread.java:1252) java.lang.Thread.join(Thread.java:1326) com.objectdb.o.IXA.i ... if there is the IndexActiovation thread and joins it. It seems it helped. Thank You! Thank you for the update and for posting the link to the workaround here. jakab