ObjectDB ObjectDB

Internal Website Search

1-10 of 17 resultsRefresh
124

avg(x)

Method javax.persistence.criteria.CriteriaBuilder Expression<Double> avg( Expression<N> x ) Create an aggregate expression applying the avg operation. Parameters: x - expression representing input value to avg operation Returns: avg expression Since: JPA 2.0
51

GROUP BY and HAVING clauses

calculations (count, sum, avg, max, min) that are carried out on all the objects (or the object tuples) in ... of numeric values. AVG - returns the average of numeric values as a double value. MIN - returns ... language: SELECT SUM(c.population), AVG(c.population) FROM Country c WHERE 'English' MEMBER OF c
25

FROM clause (JPQL / Criteria API)

reserved words: ABS, ALL, AND, ANY, AS, ASC, AVG, BETWEEN, BIT_LENGTH, BOTH, BY, CASE, CHAR_LENGTH
25

Is ObjectDB better than competing object databases?

queries (max, min, count, sum and avg). ObjectDB supports rich queries, including aggregate queries
25

JPA Query Structure (JPQL / Criteria)

GROUP BY / HAVING (groupBy, having, count, sum, avg, min, max, ...). Criteria ORDER BY (orderBy, Order, asc, desc).
25

CRUD Database Operations with JPA

see another example of a query that returns a single result: Query q2 = em.createQuery("SELECT AVG(p.x) FROM
25

ObjectDB Object Database Features

(COUNT, SUM, AVG, MAX, MIN). Query Expressions Path navigation expressions using the dot (.) operator
25

JPA Criteria API Queries

, count, sum, avg, min, max, ...). ORDER BY clause (orderBy, Order, asc, desc). The links
5

Step 3: Add a Main Class

value: Query q2 = em.createQuery("SELECT AVG(p.x) FROM Point p
5

Step 3: Add a Main Class

: Query q2 = em.createQuery("SELECT AVG(p.x) FROM Point p"); System.out.println("Average X

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