Hi folks, I´m with a problem to perform a order by in a query like this :

" select count(distinct cli.codCli) from OrdVis "

I want to order this query in a descendant order, but I can´t. I´ve tried to use a Alias to this "column" but Hibernate does not "translate" it (It uses the default naming to the column, e.g col_0_0) and throws a exception when a execute it.

I tried to use a SortedMap too, but it orders the result in a ascendant way.

Do I have to implement a Comparator ? Or there is some easier way to do this ?


Thanks




Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.2


Name and version of the database you are using: Oracle 9i

Maybe this will help you.

http://www.hibernate.org/hib_docs/v3/re ... l-ordering

Budy, I´ve seen the documentation, but , there are just a few examples ordering queries with properties. In my case, I´m selecting just a aggregate column.

I´ve seen some other examples with "count columns", and maybe the problem is with that distinct (inside the count). Something like

"Select count(cli.codCli) from OrdVis order by count(cli.codCli)" , and that just runs fine ...

Any suggestions ?

Thanks