About INNER JOIN

71-80 of 200Refresh
Manual
6

Index Definition

above, the index order should be x first and y second. Indexes on collections are useful in JOIN queries: SELECT d FROM Document d JOIN d.words w WHERE w = 'JPA' The Document entity class contains a words ... for executing the following query: SELECT d FROM Document d JOIN d.words w WHERE LENGTH(w) >= 10
Result
6

Posting to ObjectDB Website - Important Instructions

. Whenever possible: Use a single Java file with one main class + static inner classes for entity / embeddable
Result
6

Posting to ObjectDB Website - Important Instructions [2018-08-06]

. Whenever possible: Use a single Java file with one main class + static inner classes for entity / embeddable
Forum
6

multiple LEFT JOINs do not work as expected

like this: SELECT DISTINCT $1 FROM Organisation $1 JOIN $1.attributeList $2 LEFT JOIN $1.parentOrg $3 LEFT JOIN $3.parentOrg $4 WHERE ((($2.name='Attribute1') AND ($2 ... , since I use LEFT Joins this query should return all organisation under the root organisation
Forum
5

How do I achieve a Deep Fetch using JOIN FETCH?

know that I can express one level of eager fetch in JPQL as follows: SELECT c FROM C JOIN FETCH c.bList WHERE c.id=:id But when I attempt to take it to the 2nd level: SELECT c FROM C JOIN FETCH c.bList JOIN FETCH c.bList.aList WHERE c.id=:id I get an error along the lines of: Invalid fetch path
Forum
5

LazyInitialization / join fetch

descrica2_2_3_ from the User usuario0_ left outer join on area area1_ usuario0_.codigo_area = area1_.codigo left outer join on User usuario2_ usuario0_.codigo_chefe = usuario2_.codigo left outer join company empresa3_ on usuario2_.codigo_empresa = empresa3_.codigo left outer join on specialty especialid4
Forum
5

Issue with Casting / Joins

MyEntity(); entity.getEmbeddeds().put("test", new EmbeddedA); ... // Try to query using join From from = criteria.from(MyEntity.class); MapJoin join = from.joinMap("embeddeds"); Path pathToEmbeddedAName = join.value().get("name") <-- fails with attribute "name" not found
Forum
5

InternalError on multiple AND and JOIN Query

Hi, Using objectdb 2.2.8_06. Running the following query: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.contactDetails $2 JOIN $2.addresses $3 JOIN $3.attributeList $4 JOIN $2.phoneNumbers $5 JOIN $5.attributeList $6 WHERE ((($4.name='suburb') AND ($4.valueAsString='Los Angeles')) AND (($6.name='areacode
Forum
5

Lazy Init / Eager / Join Fetch collection strategy ? What to choose ?

,join fetch seems to be the right choice. What about ObjectDb ? The implementation is totally different. Is an "All eager strategy" more efficient that many join fetch ( cartesian product + distinct ... all strategy" Or "Fetch Join strategy" for ObjectDb ? Regards, Xirt > Is an "All eager strategy
Forum
5

How to use JOIN FETCH?

JOIN FETCH to avoid excessive round trips to the database: SELECT c FROM Country c JOIN FETCH c ... .   TypedQuery q = em.createQuery(         "select p from Person p join fetch p.addressHistory ... then this is normal for JOIN FETCH and you can remove duplication by using SELECT DISTINCT. The main problem