HI All,

I am using Hibernate 3.0 and Oracle 8i. I am implementing pagination where the user would like to get the results as Google.
Previous 1 2 3 4 5 6 7 8 9 Next.

After reading the articles in the forum, the only solution was to use
the follwing code.
Query query = s.createQuery(queryString);
query.setFirstResult(pageNumber * resultsPerPage);
query.setMaxResults(resultsPerPage);
List queryResult = query.list();

The query build for our search component is complex as we have various joins across different tables and the so createQuery was decided over createCriteria.

Now to get the problem is row count which will facilitate to display Previous 1 2 3 4 5 6 7 8 9 Next.

But row count is only possible using
List results = session.createCriteria(Project.class)
.setProjection( Projections.rowCount() )
.add( Restrictions.eq("name", Name.getFirstName()) )
.list();

Is ther any way where I can convert query into criteria so as to so projections ? OR any other solution to the above mentioned problem.

Thank you.

Swarup,
First, if you have complex query and big tables i advice that use ScrollableResults instead
setFirstResult/setMaxResult - it is better for Oracle, because hibernate for your solution make
ugly query with rownum and it is slow when you have big tables, order clause etc

setFirstResult/setMaxResult is preffered way for databass like mysql, postgresql - they read complete query in memory and have LIMIT clause for out of memory

oracle use cursors always and ScrollableResults is better
then you can find row count (and it is quick) with


use last 10g rel 2 driver, too

It there any answer to the original poster's question? I also use projections to count results of criteria[1] queries when building result pages but i havent found a way to do this using Query objects. Is it possible without actually loading the records from the database?

[1] http://forum.hibernate.org/viewtopic.php?t=951369