CODEWITHSUNDEEP
javahibernatehibernate-criterianhibernate-hql
Milad Khajavi
Milad Khajavi

Reputation: 2859

Join two table using Criteria in Hibernate?

I have query like this written in hql format:

Query qq = session.createQuery(
    "select question from Question question " +
    "join question.information.tags t1 " +
    "join question.information.tags t2 " +
    "where t1.name = 'java' and t2.id = 63"
        );

I wrote this query in Criteria format but it trow exception:

session.createCriteria(Question.class, "q")
        .createAlias("q.information.tags", "t1")
        .createAlias("q.information.tags", "t2")
        .add(Restrictions.eq("t1.id", "63"))
        .add(Restrictions.eq("t2.name", "java"))
        .list();

Method threw 'org.hibernate.QueryException' exception.: duplicate association path: information.tags

What is the problem? Any way to write hql in Criteria format?

Upvotes: 0

Views: 405

Answers (1)

Madhusudana Reddy Sunnapu
Madhusudana Reddy Sunnapu

Reputation: 8247

I don't think it is possible to join the same association twice with Criteria

You can find the related JIRA here that is still open.

Upvotes: 1

Related Questions