ObjectDB ObjectDB

Internal Website Search

1-10 of 200 resultsRefresh
280

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
273

LEFT (OUTER) JOIN problem when mappedBy is defined

this query: "SELECT i FROM Invoice i LEFT OUTER JOIN i.itemList items" But this query never returns invoices without items! Only invoices with items. When I remove mappedBy from @OneToMany annotation, LEFT ... Invoice i LEFT OUTER JOIN i.itemList items"); List resultList = query.getResultList
226

Query in JPA2 with LEFT JOIN on INNER JOIN

_PROFILE as col_9_0_ from ACTION action0_ left outer join ACTION_PROFILE actionprof1_ on action0_.ID=actionprof1_.ID_ACTION left outer join ACTION_PROFILE actionprof2_ on action0_.ID=actionprof2_.ID_ACTION left outer join ACTION_PROFILE actionprof3
135

FROM clause (JPQL / Criteria API)

function as implicit INNER JOIN variables. LEFT [OUTER] JOIN To understand the purpose of OUTER ... : SELECT c, p.name FROM Country c LEFT OUTER JOIN c.capital p The OUTER keyword is optional (LEFT OUTER JOIN is equivalent to LEFT JOIN). When using OUTER JOIN, if a specific outer variable does not
118

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
112

LEFT JOIN FETCH over empty embedded collection returns no results

, 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 ... list: SELECT c FROM C c LEFT JOIN FETCH c.bList LEFT JOIN FETCH c.bList.val WHERE id=:id
65

JoinType.LEFT

Enum Constant javax.persistence.criteria.JoinType LEFT Left outer join. Since: JPA 2.0
38

ObjectDB Object Database Features

). FROM (including INNER JOIN, LEFT OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL ... and array elements are indexable (extremely fast JOIN queries). Map keys and values are indexable ... fetch and JPA query FETCH JOIN. Configurable JDO fetch groups. Ease of Use and Learning ObjectDB
6

Join.outer

Annotation Element javax.jdo.annotations.Join String outer Whether to use an outer join. Returns: whether to use an outer join Default value: "" Since: JDO 2.1
3

javax.jdo.annotations.Join

. Returns: whether the join column(s) is(are) indexed Default value: "" Since: JDO 2.1 String outer Whether to use an outer join. Whether to use an outer join. Returns: whether to use an outer join Default ... javax.jdo.annotations Annotation Join Target: Classes and fields (including property get methods

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