ObjectDB ObjectDB

Internal Website Search

41-50 of 200 resultsRefresh
134

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
104

JPQL JOIN FETCH Error

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
38

javax.persistence.criteria.ListJoin

>, From<Z,E>, Join<Z,E>, Path<E>, PluralJoin<Z,List<E>,E>, Selection<E>, TupleElement<E> The ListJoin interface is the type of the result of joining to a collection over an association or element ... expression of the given type Since: JPA 2.0 Fetch<X,Y> fetch(String attributeName) Create a fetch join
38

javax.persistence.criteria.MapJoin

>, From<Z,V>, Join<Z,V>, Path<V>, PluralJoin<Z,Map<K,V>,V>, Selection<V>, TupleElement<V> The MapJoin interface is the type of the result of joining to a collection over an association or element ... a fetch join to the specified attribute using an inner join. Create a fetch join to the specified
38

javax.persistence.criteria.SetJoin

>, From<Z,E>, Join<Z,E>, Path<E>, PluralJoin<Z,Set<E>,E>, Selection<E>, TupleElement<E> The SetJoin interface is the type of the result of joining to a collection over an association or element ... expression of the given type Since: JPA 2.0 Fetch<X,Y> fetch(String attributeName) Create a fetch join
38

javax.persistence.criteria.CollectionJoin

>, FetchParent<Z,E>, From<Z,E>, Join<Z,E>, Path<E>, PluralJoin<Z,Collection<E>,E>, Selection<E>, TupleElement<E> The CollectionJoin interface is the type of the result of joining to a collection ... attributeName) Create a fetch join to the specified attribute using an inner join. Create a fetch join
38

javax.persistence.criteria.PluralJoin

<Z,E>, From<Z,E>, Join<Z,E>, Path<E>, Selection<E>, TupleElement<E> Subinterfaces: CollectionJoin, ListJoin, MapJoin, SetJoin The PluralJoin interface defines functionality that is common to joins ... attributeName) Create a fetch join to the specified attribute using an inner join. Create a fetch join
37

What are the main benefits of using ObjectDB?

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

javax.persistence.criteria.From

>, Path<X>, Selection<X>, TupleElement<X> Subinterfaces: CollectionJoin, Join, ListJoin, MapJoin ... , but may also be an embeddable belonging to an entity in the from clause. Serves as a factory for Joins ... Since: JPA 2.0 Fetch<X,Y> fetch(String attributeName) Create a fetch join to the specified attribute using
36

javax.persistence.criteria.Root

> fetch(String attributeName) Create 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 of the join Returns: the resulting fetch join Throws

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