I fell in trouble using Hibernate about "Join" clause, it bother my development plan very much.

here is a example
1) SessionFactory sessions = conf.buildSessionFactory();
2) Session s = sessions.openSession();
3) Transaction t = s.beginTransaction();
4) select new UserInfo(c.name,a.account,c.custId) from CustomerDto as c left outer join AccountDto a
5) list = s.find(sql);
...

when the program run at line 5), it throws a exception below as
net.sf.hibernate.QueryException: outer or full join must be followed by path expression [select new UserInfo(c.name,a.account,c.custId) from CustomerDto as c left outer join AccountDto a]

Why? don't Hibernate support Join clause? But I ever see some HQL using Join clause!

Please help me!

best regards

you don't show your mapping file but i suppose this should work


you're not in pure sql here, so don't forget to read all about HQL


Anthony

Successfully! The problem occur in CustomerDto.cfg.xml that don't reference to AccountDto.

Thank you very much!