<class name="Application" table="APPLICATIONS">
    <id name="id" column="APP_ID" type="java.lang.Integer" >
        <generator class="native" />
    </id>
    ...
</class>

<class name="Selection" table="SELECTIONS">
    <composite-id>
        <key-property
            name="user"
            column="SEL_USER"
            type="java.lang.String" />
        <key-many-to-one
            name="application"
            column="APP_ID"
            class="Application" />
        </key-many-to-one>
    </composite-id>
    ...
</class>

Query q = hS.createQuery("from Selection as selection " +
                         "left join fetch selection.application  " +
                         "where selection.user = :user " +
                         "order by selection.column, selection.row")
            .setString("user", username);

// if we know there is exactly 1 row, we can skip.
// it would be great if we could _always_ skip this;
// it is a problem for <key-many-to-one>

if ( isSingleRowLoader() && id!=null ) {
   resultId = id;
}
else {
   Type idType = persister.getIdentifierType();
   resultId = (Serializable) idType.nullSafeGet(rs, suffixedKeyColumns[i], session, null); //problematic for <key-many-to-one>!
   if ( id!=null && resultId!=null && id.equals(resultId) ) resultId = id; //use the id passed in
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
   
<hibernate-mapping package="socnav.services.data">

    <class name="TemplCourseOneWayXfer" table="soc_templ_course_one_way_xfer">

        <composite-id>
            <key-many-to-one name="templateCourse" class="TemplateCourse" column="course_id"/>
            <key-many-to-one name="courseCatCode" class="CourseCatCode" column="course_cat_code_id"/>
        </composite-id>

        <!-- duplicate of courseCatCode in key; I am able to specify the
             fetch="join" here, which I can't do in the composite-id;
             I had to change the case of the column name to avoid duplicate
             column name exceptions when the configuration is loaded -->
        <many-to-one name="courseCatCode" class="CourseCatCode" column="Course_cat_code_id" not-null="true" fetch="join"/>

    </class>

</hibernate-mapping>