Joining on the Same Table - How to Do ?

bengrant · **Joined:** Wed Sep 13, 2006 7:24 am **Posts:** 26

Hibernate version: 3.1

In Code we are trying to join on the same table twice, but with different alias. The criteria query is not happy about it

see error:

Code:

org.hibernate.QueryException: duplicate alias: multiStatic
        at org.hibernate.loader.criteria.CriteriaQueryTranslator.createAliasCriteriaMap(CriteriaQueryTranslator.java:128)
        at org.hibernate.loader.criteria.CriteriaQueryTranslator.<init>(CriteriaQueryTranslator.java:79)
        at org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:58)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1514)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)

In SQL i can do Select * from TableA a, TableA, b where a.id=b.=id, so why can i not do a join on the same table twice.

you can not do

Code:

myCriteria.createCriteria("feed.multiStatic", "static1", Criteria.LEFT_JOIN)
myCriteria.createCriteria("feed.multiStatic", "static2", Criteria.LEFT_JOIN)

Any suggestions on how this can be overcome welcome ...

Thanks