I am trying to order a collection that I am eagerly fetching but cannot seem to come up with the correct criteria call. I have speciefied that the collection should be ordered in the mapping but that seems to get discarded if I do an Eager fetch.

Here is the mapping



Here is the current code that ignores the order by in the mapping:




I have an order by sequence set for the root step list but I also need the substeps ordered.

I have tried to specify subcriteria and order the collection that way but I get an exception that states that subcriteria cannot be ordered.

I would appreciate any advice on this.

Thanks.

Should I just do this with HQL? I'd prefer to use the criteria query, but if nobody has any input, then I guess HQL will do the job. It just seems that there may be a bug if the order-by of the mapping file is getting ignored.

sorry, i never saw the original post. you cannot (yet) order by a subcriteria. i agree that the mapping file should still apply when doing an eager fetch but i too have noticed that it doesn't. perhaps you can make an enhancement request?