how to create two aliases for same entity with createCriteri

venkatpuru · **Posted:** Fri Oct 17, 2008 11:32 am

Hi All,

I have a scenario like below.

Criteria studentCriteria = s.createCriteria(Student.class);
studentCriteria.createCriteria("preferredCourse", "preferredCourse1", Criteria.LEFT_JOIN);
studentCriteria.createCriteria("preferredCourse", "preferredCourse2", Criteria.LEFT_JOIN);

When I used the above I am getting an error show below.
org.hibernate.QueryException: duplicate association path: impactImperatives
at org.hibernate.loader.criteria.CriteriaQueryTranslator.createAssociationPathCriteriaMap(CriteriaQueryTranslator.java:141)

please do the needful.

Thanks in advance.

Regards,

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

I believe multiple aliasing can't be done in using Criteria, and they are not in a hurry to implement this feature, either.

You can use HQL, instead:

Code:

      Query query=session.createQuery(" 
                                  select s from Student s
                                  left join s.preferredCourse pc1
                                  left join s.preferredCourse pc2" );
      query.list();