ObjectDB ObjectDB

Internal Website Search

1-10 of 35 resultsRefresh
101

GROUP BY and HAVING clauses

calculations (count, sum, avg, max, min) that are carried out on all the objects (or the object tuples) in ... functions of SQL: COUNT - returns a long value representing the number of elements. SUM - returns the sum ... that use that currency: SELECT c.currency, SUM(c.population) FROM Country c WHERE 'Europe' MEMBER
96

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
95

sum(x, y)

Method javax.persistence.criteria.CriteriaBuilder Expression<N> sum( N x, Expression<?> y ) Create an expression that returns the sum of its arguments. Parameters: x - value y - expression Returns: sum Since: JPA 2.0
95

sum(x, y)

Method javax.persistence.criteria.CriteriaBuilder Expression<N> sum( Expression<?> x, N y ) Create an expression that returns the sum of its arguments. Parameters: x - expression y - value Returns: sum Since: JPA 2.0
95

sum(x, y)

Method javax.persistence.criteria.CriteriaBuilder Expression<N> sum( Expression<?> x, Expression<?> y ) Create an expression that returns the sum of its arguments. Parameters: x - expression y - expression Returns: sum Since: JPA 2.0
34

Numbers in JPQL and Criteria Queries

= cb.parameter(Integer.class); // Addition (+) Expression<Integer> sum1 = cb.sum(path, param); // 2 expressions Expression<Integer> sum2 = cb.sum(path, 1000); // expression + number Expression<Integer> sum3 = cb.sum(1000, path); // number + expression // Subtraction
31

Wrong type on SUM function

(         "SELECT cc.totalCC.moneda, SUM(cc.totalCC.importe) FROM ComprobanteContable cc " +         "WHERE cc ... ", this).getResultList(); The problem is about SUM on cc.totalCC.importe, a BigDecimal field. It works fine on all groups giving to me the correct sum BigDecimal value, except in one group
29

javax.persistence.criteria.CriteriaBuilder

Expression<N> sum( Expression<N> x) Create an aggregate expression applying the sum operation. Create an aggregate expression applying the sum operation. Parameters: x - expression representing input value to sum operation Returns: sum expression Since: JPA 2.0 Expression<N> sum( Expression<?> x, N y
28

JPA Criteria API Queries

, count, sum, avg, min, max, ...). ORDER BY clause (orderBy, Order, asc, desc). The links ... , currentDate, ...). Paths, navigation and types (get, type). Arithmetic expressions (sum, diff, prod
19

ORDER BY clause (JPQL / Criteria API)

can order these groups. For example: SELECT c.currency, SUM(c.population) FROM Country c

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