count query result

snorbi · **Joined:** Fri Apr 02, 2004 9:57 am **Posts:** 14

Hello,

How can I count the number of results of a query without returning the result values? (It would be difficult to create another query for counting because the queries are not created by me.)

SQL have the following:

select count(*) from (some subquery)
eg. select count(*) from (select * from countries)

but HQL doesn't allow me to write:

select count(*) from (from some.package.Country)

Thanks for any help,
Norbi

mdavison · **Joined:** Tue Dec 09, 2003 4:45 pm **Posts:** 14

Norbi,

Try something like

Code:

List l = session.find("select count(obj) from com.foo.bar.Obj as obj");
Iterator it = l.iterator();
if (it.hasNext()) {
  Number n = (Number)it.next();

  //do something with n.intValue()
}

snorbi · **Joined:** Fri Apr 02, 2004 9:57 am **Posts:** 14

Thanks for the reply, but I'd like to apply this "counter" on generic queries.

My concrete question is: how can I write a HQL query to express the following SQL:

select count(*) from (complex subquery)

Because HQL does not allow this with this syntax.

Thanks,
Norbi