Hibernate version: version 3.1.3
Name and version of the database you are using: 4.1.13-standard

3 tables, parent, child & priority

parent
-parentId
-colA

child
-childId
-colB
-priorityId

priority
-priorityId
-seq

The mapping for parent, of course, contains a set element for the child.

Quesion: Is there a way to tell Hibernate to use priority.seq for sorting the children? I am using a comparator now (sort="PolicyComplianceComparator") and this works but it might be simplier and faster to just use the db, joining child & priority.

I know about the where attribute of the set element but i believe it requires the col to be in the child table??? I also that a "loader" exists although I have used it or even seen an example. Is this the way to go?

Thanks for your help,

Jeff

OK, I believe that "16.5. Custom SQL for loading" answers my question.