Home » Search

About join

191-200 of 200Refresh
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
Result
1

ObjectDB version 2.2.9

). Fixed a JMX Remote - ObjectDB Enhancer Agent conflict. Fixed a ClassCastException bug in complex JOIN ... criteria queries (issue #369). Fixed a bug in using primary key in results of a JOIN query. Fixed
Result
1

ObjectDB version 2.4.0

web application (by catching unexpected exception). Fixed LEFT [OUTER] JOIN issues (including ... expressions in queries. Fixed handling null values in JOIN and path expressions in queries. Fixed a possibly
Result
1

ObjectDB version 2.5.0

Version 2.5.0 Added support of nested paths in JOIN FETCH. Added support of persisting collections and maps of user defined types. Added support of Google (Guava) collections. Added support ... key inheritance. Fixed a bug in JOIN FETCH. Fixed a bug in loading reference primary key field
Result
1

ObjectDB version 2.5.1

Version 2.5.1 Added support of editing enum values in the Explorer. Added logging of type registration. Added error message when using mapped by (inverse) collections and maps of invalid types. Changed JOIN FETCH to act as LEFT JOIN in path expressions. Updated the PDF manual. Fixed a possible