Using HQL:

* I know how to get the total number of results for a query.

* I know how to get a list of Object IDs back for that same query.

Can I use HQL to get the index of a specific Object ID in that list? The only way I know to do this is to get back all of the results from the database, then look through all of the results.

Since I am using Oracle as my database, it seems that one way I could solve my question is to:

1. sort in a subquery
2. determine which item in the subquery matches the id of 'the object i want to know the sorted index of'.
3. return the value of the matching magic/psuedo-column rownum

I see that rownum is used 'under the hood' for pagination in Hibernate when using Oracle.

However, I can't seem to configure even a simple query query correctly.



Any suggestions for how to properly access rownum in my own HQL queries?

It has come to my attention that I might be able to retrieve my query result list as "extra-lazy", and then find out the index of an item in that result list using indexOf().

However, I cannot figure out how to specify that my HQL result list items should be "extra-lazy".

(I do see how an object's collection can be extra-lazy by specifying it in hbm.xml, but I am looking for the ordered items items in my result set to be extra-lazy.)