ObjectDB ObjectDB

Internal Website Search

41-50 of 200 resultsRefresh
140

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
109

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
40

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
40

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
39

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
38

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
38

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
27

Paths and Types in JPQL and Criteria API

. It might be easier to understand exactly how this works by considering the equivalent JOIN query. Entity ... are represented in the JPA Criteria API by the Path interface and by its subinterfaces (From, Root, Join and Join's descendants). Path Expressions The Root and Join interfaces (which are subinterfaces
21

ObjectDB Object Database Features

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 ... ). FROM (including INNER JOIN, LEFT OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL
21

javax.persistence.criteria.Fetch

javax.persistence.criteria Interface Fetch<Z,X> Superinterfaces: FetchParent<Z,X> Represents a join ... 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