About join

191-200 of 200Refresh
Forum
2

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

Strange Error with Criteria API and Sorting

.Join; import javax.persistence.criteria.Root; public class Test_OrderBy { public static void ... root = query.from(TestEntity.class);   final Join otherJoin = root.join ... in thread "main" [ObjectDB 2.4.4_08] SELECT DISTINCT $1 FROM TestEntity $1 JOIN $1.other $2 ORDER
Forum
2

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