ObjectDB ObjectDB

Internal Website Search

11-20 of 35 resultsRefresh
30

Problem of query With an aggregate function

Hi I would know if this type of query is supported By JPA: select sum(nb1), sum(nb2), sum(nb3 ... > sommeClassesRep(Choix choix) { Query listClassRepHost = em.createQuery("SELECT SUM(h.nb1xx), SUM(h.nb2xx),SUM(h.nb3xx),SUM(h.nb4xx),SUM(h.nb5xx) FROM HttpEntity h WHERE h.host = :host and h.date_http BETWEEN
21

Is ObjectDB better than competing object databases?

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

JPA Query Expressions (JPQL / Criteria)

, navigation and types (get, type). Arithmetic expressions (sum, diff, prod, quot, mod, abs, neg
21

JPA Query Structure (JPQL / Criteria)

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

ObjectDB Object Database Features

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

ORDER BY clause (JPQL / Criteria API)

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

find() cost unreasonable time!

@ 0.000000 The sum : 18 Class of Nodes: @Entity @Inheritance(strategy=InheritanceType.JOINED ... ", (System.currentTimeMillis()-start)/1000f);   }   System.out.printf("The sum : %d %n", iSum ... ", (System.currentTimeMillis()-start)/1000f);   }   System.out.printf("The sum : %d %n", iSum
21

How to convert a boolean to an int in the query?

, approvePhoneNumber, .... because the parameters equivalent. I want to sort them in the query by their sum ... for your help galandor Orlov Sergey Consider adding an int field to your entity class, that will sum ... .select(intApproveEmail); q.orderBy(cb.desc(cb.sum(intApproveEmail, intApprovePhoneNumber
11

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
11

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

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