ObjectDB ObjectDB

Internal Website Search

51-60 of 200 resultsRefresh

Left join fetch behaviour doesn't retrieve children?

Hello, I'm a little bit confused about a left join fetch behaviour. In this test case, i try to fetch my 3 children using a left join fetch. But my collection is null after closing the em ... left join fetch         em = emf.createEntityManager();         TypedQuery<MyEntity> query

LEFT JOIN FETCH over empty embedded collection returns no results

First of all, thank you for promptly implementing JOIN FETCH over nested paths in response ... , but I attempt to LEFT JOIN FETCH all the members of a collection within a (non-existent) member ... where bList is empty, the following works (returns my instance of C): SELECT c FROM C c LEFT JOIN FETCH

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

How do I achieve a Deep Fetch using JOIN FETCH?

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

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

Query with FETCH JOIN returns multiple results instead of one.

jpqlResult = em.createQuery( "SELECT d FROM Demand d JOIN FETCH d.services WHERE d=:demand ... duplicates with DISTINCT: SELECT DISTINCT d FROM Demand d JOIN FETCH d.services WHERE d=:demand ... : SELECT d FROM Department d LEFT JOIN FETCH d.employees WHERE d.deptno = 1 "A fetch join has the same

Issue with Casting / Joins

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

Possible issue for JPQL "LEFT [OUTER] JOIN"

Possible issue for JPQL "LEFT [OUTER] JOIN" is doing "[INNER] JOIN". Thanks. eurojet P. F. Martinez ... A a LEFT OUTER JOIN a.listB b WHERE b IS NULL" where the output would be [A4, null] or even throw ... FROM A a LEFT OUTER JOIN a.listB b WHERE b.id IS NULL" but it works fine with an relationship

Criteria Query From Elements

(bound by an entity class) are represented by the Root subinterface: Join variables (bound by an attribute of a preceding variable in the FROM clause) are represented by the Join subinterface and its descendant interfaces: See the FROM in Criteria Queries section for more details and examples. Join


, Join, ListJoin, MapJoin, PluralJoin, Root, SetJoin Represents an element of the from clause ... a fetch join to the specified attribute using an inner join. Create a fetch join to the specified attribute using an inner join. Parameters: attributeName - name of the attribute for the target

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support