Home » Search

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

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

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

Detaching objects after JOIN FETCH

Hi, I have a question about detaching objects after issuing query with JOIN FETCH. Let's say I ... to fetch all B classes with all A classes skipping lazy loading: select b from B b join fetch b ... is closed, B.aClasses is always null. I thought, that after join fetch and CascadeType.DETACH list