ObjectDB ObjectDB

Internal Website Search

1-10 of 76 resultsRefresh
34

Query in JPA2 with LEFT JOIN on INNER JOIN

How write a query in JPA2 with LEFT JOIN on INNER JOIN? select a.description, a.id, p1.description, p2.description,p3.description from action a left join action_profile ap1 on ap1.id_action=a.id inner join profile p1 on ap1.id_profile=p1.id and p1.name='?' left join action_profile ap2 on ap2
32

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
31

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
30

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
29

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
28

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
16

JoinType.LEFT

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

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
6

Database Explorer

automatically. Tabbed Windows Three tabbed windows are displayed on the left side of the Explorer ... viewer to focus on the selected object. Executing Queries The [Query] window on the left side enables ... of different Explorer components. Select one or more elements on the left side and then use
0

[ODB1] Chapter 9 - ObjectDB Explorer

Windows Four tabbed windows are displayed on the left side of the Explorer desktop when a database ... . Executing JDOQL queries The "Query" tabbed window on the left side of the Explorer desktop enables ... window on the left side of the Explorer desktop lists all the persistent classes in the database

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