ObjectDB Database Search

1-6 of 6 results

jakarta.persistence.criteria.CriteriaBuilder.sum(Expression)

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sum (    Expression x ) Create an aggregate expression applying the sum operation. Parameters: x - expression representing input value to sum operation Returns: sum expression. Since: Jakarta Persistence (JPA) 1.0

jakarta.persistence.criteria.CriteriaBuilder.sumAsLong(Expression)

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsLong (    Expression x ) Create an aggregate expression applying the sum operation ... value to sum operation Returns: sum expression. Since: Jakarta Persistence (JPA) 1.0

jakarta.persistence.criteria.CriteriaBuilder.sumAsDouble(Expression)

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsDouble (    Expression x ) Create an aggregate expression applying the sum operation ... value to sum operation Returns: sum expression. Since: Jakarta Persistence (JPA) 1.0

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 ... 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 to_date

Performance issues on aggregate query

we are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1.objectName, sum (p4.doubleValue), sum (p4.doubleValue*p5.doubleValue),0,p7.doubleValue,p3.name,count(o) from ObjectNode o INNER JOIN o.properties p1 INNER JOIN o.properties p2  INNER JOIN o

find() cost unreasonable time!

, sons:2 child : 18 child : 19 Iterator time @ 0.000000 The sum : 18 Class of Nodes: @Entity