I am trying to retrieve the number of rows returned with out retrieving the data, can anyone help me how to do this.

I tried some thing like this
select count(*) from table11 join.. where ....

Usually select .. from ... returns a list but I need the result into an int variable which gives me the number of rows with out bringing in the rows.

From the docs (http://www.hibernate.org/hib_docs/refer ... hql-select
)

You can find the size of a collection without initializing it:

( (Integer) session.iterate("select count(*) from ....").next() ).intValue();