ObjectDB ObjectDB

Internal Website Search

11-20 of 31 resultsRefresh
22

Numbers in JPQL and Criteria Queries

Numeric values may appear in JPQL queries in many forms: as numeric literals - e.g. 123, -12.5. as parameters - when numeric values are assigned as arguments. as path expressions - in navigation to persistent numeric fields. as aggregate expressions - e.g. COUNT. as collection functions
22

Paths and Types in JPQL and Criteria API

all these objects (this is an aggregate query with no GROUP BY - all the objects are considered as
6

count(x)

Method javax.persistence.criteria.CriteriaBuilder Expression<Long> count( Expression<?> x ) Create an aggregate expression applying the count operation. Parameters: x - expression representing input value to count operation Returns: count expression Since: JPA 2.0
6

countDistinct(x)

Method javax.persistence.criteria.CriteriaBuilder Expression<Long> countDistinct( Expression<?> x ) Create an aggregate expression applying the count distinct operation. Parameters: x - expression representing input value to count distinct operation Returns: count distinct expression Since: JPA 2.0
6

sum(x)

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

sumAsDouble(x)

Method javax.persistence.criteria.CriteriaBuilder Expression<Double> sumAsDouble( Expression<Float> x ) Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result. Parameters: x - expression representing input value to sum operation Returns: sum expression Since: JPA 2.0
6

sumAsLong(x)

Method javax.persistence.criteria.CriteriaBuilder Expression<Long> sumAsLong( Expression<Integer> x ) Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result. Parameters: x - expression representing input value to sum operation Returns: sum expression Since: JPA 2.0
6

min(x)

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

javax.jdo.Query

to obtain persistent instances, values, and aggregate data from the data store. The PersistenceManager ... must either be an expression contained in the grouping, or an aggregate evaluated once per group. Parameters ... field values (projections) and aggregate function results. Parameters: data - a comma-delimited list
0

setResult(data)

. If set, this query will return expressions, including field values (projections) and aggregate ... , or aggregate functions) to return from this query Since: JDO 2.0

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