Hello,

I'm using Hibernate 3.3 and everything works more or less :)
But I found that Hibernate is adding an "order by" when using the criteria API because one of the entity used in the criteria has an @OrderBy annotation. This is a problem because I'm using "avg" function and "group by", so my the generated sql doesn't work because I get a "ORA-00979: not a GROUP BY expression"...
Is there a way to remove the automatically added "orderby" ? I would like to avoid removing the annotation.

Hope I'm clear :)

Thanks

As far as I'm concerned the only way is to remove the annotation ...
Or you could write your own HQL query from scratch ...
But it would be a complete mess if you could enable/disable the annotations as you like!