Eclipse Community Forums: EclipseLink » criteria API: select count(*) from ..

Help

Home

Home » Eclipse Projects » EclipseLink » criteria API: select count(*) from ..

Show: Today's Messages :: Show Polls :: Message Navigator

criteria API: select count(*) from .. [message #487130]

Tue, 22 September 2009 01:27

Serge
Messages: 76
Registered: July 2009

Member

Is it correct usage?

EntityManager em = getEntityManager();
try {
QueryBuilder qb = em.getQueryBuilder();
CriteriaQuery cq = qb.createQuery();
Root<DiscountCode> dc = cq.from(DiscountCode.class);
cq.select(qb.count(dc));
Query q = em.createQuery(cq);
return ((Long) q.getSingleResult()).intValue();
} finally {
em.close();
}

if yes, then I got two issues here in eclipselink 2.0 M7, return value
is double (may be known issue
https://bugs.eclipse.org/bugs/show_bug.cgi?id=289830)
and value is powered in two, i.e. if I have 6 rows result will be 36.0,
after addition of one more row I have result 49.0, it may be somehow
related to issue https://bugs.eclipse.org/bugs/show_bug.cgi?id=245653
but may be another one.

Report message to a moderator

[Message index]

		criteria API: select count(*) from .. By: Serge on Tue, 22 September 2009 01:27
		Re: criteria API: select count(*) from .. By: James Sutherland on Thu, 24 September 2009 09:47
		Re: criteria API: select count(*) from .. By: Serge on Thu, 24 September 2009 13:01
		Re: criteria API: select count(*) from .. By: Serge on Thu, 24 September 2009 13:09
		Re: criteria API: select count(*) from .. By: Serge on Thu, 24 September 2009 13:55
		Re: criteria API: select count(*) from .. By: Serge on Fri, 25 September 2009 05:18
		Re: criteria API: select count(*) from .. By: Serge on Thu, 24 September 2009 13:06

Previous Topic:	Inheritance problem with Id in subclass
Next Topic:	Unknown entity type

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 13:18:32 EDT 2013