Hi all,

I have this query:

Query locationQuery = session.createQuery("select count(*) " +
"from Location as location where " +
"location.comp_id.lsecurityId = :securityCode and location" +
".lcellStatus is not null");

assuming that the syntax is correct, how do I get the 'count' value out of the query object?

TIA,

The count(*) aggregate function has a return type of Hibernate.INTEGER, eg, Java Integer. When you do qry.find(...) you will get a list with one element that is an Integer.