ObjectDB ObjectDB

Internal Website Search

21-30 of 200 resultsRefresh
21

GROUP BY and HAVING clauses

that use that currency: SELECT c.currency, SUM(c.population) FROM Country c WHERE 'Europe' MEMBER ... Country c WHERE 'Europe' MEMBER OF c.continents GROUP BY c.currency HAVING COUNT(c) > 1 ... language: SELECT SUM(c.population), AVG(c.population) FROM Country c WHERE 'English' MEMBER OF c
15

FROM clause (JPQL / Criteria API)

WHERE c2 MEMBER OF c1.neighbors Multiple variables are equivalent to nested loops in a program ... , INDEX, INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH, LIKE,LOCATE, LOWER, MAX, MEMBER, MIN, MOD, NEW
15

Logical Operators in JPQL and Criteria API

instances) and return a new Predicate instance: Predicate p1 = cb.and(isInUN, isInEU); // Member of both UN and EU Predicate p2 = cb.or(isInOECD, isLarge); // Either OECD member or large
15

JPA Metamodel API

reflection representation of the field (or property) type: Member member = attr.getJavaMember
11

javax.persistence.criteria.CriteriaBuilder

) Create a predicate that tests whether an element is a member of a collection. Create a predicate that tests whether an element is a member of a collection. If the collection is empty, the predicate will be false. Parameters: elem - element collection - expression Returns: is-member predicate
10

ORDER BY clause (JPQL / Criteria API)

WHERE 'Europe' MEMBER OF c.continents GROUP BY c.currency HAVING COUNT(c) > 1 ORDER BY c.currency The ORDER
10

ObjectDB Object Database Features

& functions (LIKE, CONCAT, TRIM, SUBSTRING, ...). JPQL collection operators & functions (IS EMPTY, MEMBER
10

JPA Query Expressions (JPQL / Criteria)

] MEMBER [OF] and the [NOT] LIKE operator. Logical operators: AND, OR, NOT. In addition, JPA queries
9

javax.persistence.criteria.From

) Create a predicate to test whether the expression is a member of the argument list. Create a predicate to test whether the expression is a member of the argument list. Parameters: values - values ... <?> values) Create a predicate to test whether the expression is a member of the collection. Create
1

[ODB1] Chapter 3 - Persistent Classes

class), interface implementations, inner classes, etc. The class members (constructors, 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