Hello,
We are currently using Hibernate in 3 tire architecture with Swing client on front end. We are using pagination from Hiberanate framework (Oracle db)
and it is working excellent. Now the problem lies in the fact that on clinet we are displaying 100 records at time with next previous button....but we have to show the client total number of records the query returned. So on back end DAO i have to do two quries the count of results and actual results. To optimize the things we run the count quer once in the first iteration. I think it wil be convinient for us if hibernate returns the no. of records itself beacuse we have to write number of lines of code to incorporate this as we are using dyanmic queirs. So a feature request

Regards,
Shoaib Akhtar

This surely won't happen. Do your count queries yourself.

Hello,
Thanks for your reply. It was only a suggestion... a very humble one.... can hibernate have a boolean to return the count from query (in that case hibernate may made second query for getting count ) by default it wil be false so no overhead.can we?

Regards,
Shoaib Akhtar

I wrap this type of business function in helper methods/class. I don't think it belongs in hibernate itself.