ObjectDB ObjectDB

Internal Website Search

21-30 of 31 resultsRefresh
16

IN expression in a Criteria Query

.objectdb.o.UserException: Invalid result expression 'a' for an aggregate query at com.objectdb.o.MSG ... value combination). Aggregate calculations (count, sum, avg, max, min) that are carried
16

How to query for list of lists ?

.util.List' for an aggregate query at com.objectdb.o.MSG.d(MSG.java:61) at com.objectdb.o.QRC.G(QRC ... Adding more details: I get the same error: "Invalid result expression 'java.util.List' for an aggregate
11

Queries are slow on a large database

.JDOUserException Invalid context for aggregate 'count' (error 743) (position 0) at com.objectdb.jdo.JdoQuery
11

composite index not used in query

.classIdentifier='(TC)'). Step 4: Group results --------------------- Evaluate aggregate expressions
6

max(x)

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

greatest(x)

Method javax.persistence.criteria.CriteriaBuilder Expression<X> greatest( Expression<X> x ) Create an aggregate expression for finding the greatest of the values (strings, dates, etc). Parameters: x - expression representing input value to greatest operation Returns: greatest expression Since: JPA 2.0
6

least(x)

Method javax.persistence.criteria.CriteriaBuilder Expression<X> least( Expression<X> x ) Create an aggregate expression for finding the least of the values (strings, dates, etc). Parameters: x - expression representing input value to least operation Returns: least expression Since: JPA 2.0
6

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
3

Issue with UPPER ?

--------------------- Evaluate aggregate expressions:   count($1). Step 11: Apply selection ... aggregate expressions:   count($1). Step 11: Apply selection ----------------------- Apply selection ... results --------------------- Evaluate aggregate expressions:   count($1). Step 11: Apply
0

setGrouping(group)

Method javax.jdo.Query void setGrouping( String group ) Set the grouping expressions, optionally including a "having" clause. When grouping is specified, each result expression must either be an expression contained in the grouping, or an aggregate evaluated once per group. Parameters: group

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