Something

class Author{    @Id    @Column(name="person_id")    private long id;    @Column    private String name;}class Article{    @ManyToOne @JoinColumn(name="author_id")    private Author author;}class SubmissionResult{    @Id // part of @IdClass    private Article article;    @Id // part of @IdClass    private Magazine magazine;}// dao search method:Criteria search = getSession().createCriteria(SubmissionResultBean.class)                .add(Restrictions.eq("magazine.id", magazine.getId()));        if (null != rating) {    search.add(Restrictions.eq("rating", rating));}if (!includeDelayed) {    search.add(Restrictions.isNull("delayedUntil"));}search.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);search.createAlias("article", "ar");search.createAlias("ar.author", "arAuthor");search.addOrder(Order.asc("arAuthor.name"));