Collection getAllAnswers(String examId) {
    Query q = session.createQuery("FROM answers WHERE examId = ? ORDER BY personId, questionId");
    q.setParameter(0, examId);
    return q.list();
}

static int PAGE_SIZE = 1000;
Query q;

Iterator getFirstPage(String examId) {
    q = session.createQuery("FROM answers WHERE examId = ? ORDER BY personId, questionId");
    q.setParameter(0, examId);
    q.setMaxResults(PAGE_SIZE);
    q.setFirstResult(-PAGE_SIZE);
    return getNextPage();
}

Iterator getNextPage() {
    nextResult += PAGE_SIZE;
    q.setFirstResult(nextResult);
    return q.iterate()
}

CREATE TABLE answers (
    questionId varchar(30) not null,
    value text,
    personId varchar(60) not null,
    examId varchar(30) not null,
    person_type int unsigned(2) default '0' not null)
    PRIMARY KEY (questionId, personId, examId, person_type)
);

<hibernate-mapping>
    <class
        name="br.com.company.AnswerBean"
        table="resposta"
        dynamic-update="false"
        dynamic-insert="false"
    >

        <composite-id>
            <key-property name="questionId" column="questionId "/>
            <key-property name="personId" column="personId"/>
            <key-property name="personType" column="person_type"/>
            <key-property name="examId" column="examId "/>
        </composite-id>

        <property
            name="value"
            type="java.lang.String"
            update="true"
            insert="true"
            access="property"
            column="value"
        />

    </class>
</hibernate-mapping>

public class AnswerBean
    implements Serializable
{
    private String questionId;
    private String personId;
    private String value;
    private String examId;
    private String personType;
   
    public AnswerBean() {
        // no-args ctor for Hibernate
    }
   
    public AnswerBean(String id, String questionario, String personId, String value, String personType)
    {
        super();
        this.personId = personId;
        this.questionId = questionId;
        this.examId = examId;
        this.value = value;
        this.personType = personType;
    }
   
    public String getQuestionId()
    {
        return questionId;
    }
    public void setQuestionId(String questionId)
    {
        this.questionId = questionId;
    }

    public String getValue()
    {
        return value;
    }
    public void setValue(String value)
    {
        this.value = value;
    }

    public String getPersonId()
    {
        return personId;
    }
    public void setPersonId(String personId)
    {
        this.personId = personId;
       
    }

    public String getExamId()
    {
        return examId;
    }
    public void setExamId(String examId)
    {
        this.examId = examId;
    }

    public String getPersonType() {
        return personType;
    }

    public void setPersonType(String personType) {
        this.personType = personType;
    }

    public String toString() {
        return "AnswerBean (" +
            "personId=" + personId +
            ", personType=" + personType +
            ", examId=" + examId +
            ", questionId=" + questionId +
            ", value=" + value + ")";
    }

    public boolean equals(Object other) {
        if (! (other instanceof AnswerBean)) {
            return false;
        }
        AnswerBean outra = (AnswerBean) other;
        return questionId != null && questionId.equals(outra.getQuestionId())
            && personId != null && personId.equals(outra.getPersonId())
            && personType != null && personType.equals(outra.getPersonType())
            && examId != null && examId.equals(outra.getExamId());
    }

    public int hashCode() {
        if (questionId == null || personId == null || personType == null || questionId == null) {
            return 0;
        }
        return questionId.hashCode() + personId.hashCode() + personType.hashCode()
            + examId.hashCode();
    }

}