a query “SELECT COUNT(*) FROM NOME_DA_CLASSE_MODEL”, retorna um número,
e não uma lista de registros.
Portanto, troque seu método .getResultList() para getSingleResult();
Experimente desta forma:
[code] @SuppressWarnings(“unchecked”)
public int count() throws DaoException {
return imsDBMng.getManager().createQuery("select count(*) from " + domainClass.getName()).getSingleResult();
@SuppressWarnings("unchecked")
public int count() throws DaoException {
return (Integer) imsDBMng.getManager().createQuery(
"select count(0) from " + domainClass.getName() ).getSingleResult();
}
e deu esse erro
class = br.com.certisign.ims.data.model.device.ImsDeviceVendor
- line 1:14: unexpected token: 0
- processEqualityExpression() : No expression to process!
Exception in thread "main" java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 0 near line 1, column 14 [select count(0) from br.com.certisign.ims.data.model.device.ImsDeviceVendor]
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:624)
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:96)
at br.com.certisign.core.persistence.AbstractBaseDao.count(AbstractBaseDao.java:143)
at br.com.certisign.ims.data.persistence.teste.main(teste.java:199)
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 0 near line 1, column 14 [select count(0) from br.com.certisign.ims.data.model.device.ImsDeviceVendor]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:93)
... 2 more