I'm using Hibernate 2.1.3.
I'm implementing a paging solution for queries.
I coded it this way with some help from an Eclipse plugin named Hibernate Synchronizer:
public function getNamedQueryPageable(String name, Map params, session s,int maxresults,int firstresult)
Query q = s.getNamedQuery(name);
if (null != params) {
for (Iterator i=params.entrySet().iterator(); i.hasNext(); ) {
Map.Entry entry = (Map.Entry) i.next();
setParameterValue(q, (String) entry.getKey(), entry.getValue());
}
}
q.setFirstResult(firstresult);
q.setMaxResults(maxresults);
return q.list();
}
My problem occurs when i tried to get the number of total rows that results from the query, not only the number of rows that I retrieved.
I could make a siple query: "select count(*)..." as decribed in documentation, but I want to know if there is a simpler way.
If there isn't, what do you think about a feature request for this ability in the class Query.
_________________ Thank you!
|