How do you get the eqvivilent of a Row Count

Tom · **Joined:** Tue May 11, 2004 10:21 am **Posts:** 20

How would you write the statement in HSQL of:
rowCount = resultSet.getRow(); ?

TIA

Tom K.

anthony · **Posted:** Thu May 20, 2004 3:51 pm

http://www.hibernate.org/hib_docs/refer ... ggregation

if your hql is "from Object"
just execute "slect count(obj) from Object as obj"

chaganthi · **Posted:** Thu May 20, 2004 3:53 pm

Check out the tips from Section 10.13 from the Hibernate docs.

If I understood your question right, One of the examples there maybe helpful to you.

Madhu

Tom · **Joined:** Tue May 11, 2004 10:21 am **Posts:** 20

I need to return the count and would like to combine a command that I don't have combine with another one.

I suppose I could do as suggested and do a
session.find("select count(a) from AdInfoView as a");

and convert it to an int?