Fast Object Database for Java - with JPA/JDO support

Internal Website Search

51-60 of 200 resultsRefresh


Annotation Element javax.jdo.annotations.Join String foreignKey Name for a generated foreign key constraint. Returns: the name of the generated foreign key constraint Default value: "" Since: JDO 2.1

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

Multiple joins did not return expected result

a specific calendar by its id like: SELECT event FROM Calendar c1, SharedCalendar c2 INNER JOIN AS event INNER JOIN AS event WHERE OR Unfortunately ... FROM Calendar c1, SharedCalendar c2 INNER JOIN AS event1 INNER JOIN

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

Query with FETCH JOIN returns multiple results instead of one.

join semantics as the corresponding inner or outer join, except that the related objects specified ... jpqlResult = em.createQuery( "SELECT d FROM Demand d JOIN FETCH WHERE d=:demand ... duplicates with DISTINCT: SELECT DISTINCT d FROM Demand d JOIN FETCH WHERE d=:demand

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 IS NULL" but it works fine with an relationship

What are the main benefits of using ObjectDB?

that ability and require multiple tables, multiple records and join operations in order to support


, Comparable Defines the three types of joins. Right outer joins and right outer fetch joins are not required to be supported in Java Persistence 2.0. Applications that use RIGHT join types will not be portable. Since: JPA 2.0 JoinType INNER Inner join. Inner join. Since: JPA 2.0 JoinType LEFT

JPA Persistable Types

: should be a top-level class (i.e. not a nested / inner class). should have a public or protected no-arg ... is slightly less restrictive: Static nested entity classes are allowed (non static inner classes


Hello I get an error when executing the following JPQL query: select doi from Doi doi left join fetch doi.metadata metadata left join fetch metadata.titles titles left join fetch metadata.creators creators left join fetch metadata.descriptions descriptions left join fetch metadata

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