Left outer join in hibernate 3.1 Criteria API --------------------------------------------- Key: HHH-2182 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2182 Project: Hibernate3 Type: Bug Versions: 3.1 Environment: Running with Spring framework on weblogic server. Reporter: Dinesh Kumar Gupta I have required a left outer join implementation in Hibernate criteria API in my project. When I create a alias or a sub croteria by criteria.createCriteria it puts a inner join. Is there any way to use left outer join in Hibernate 3.1 criteria API if possible then how. My code is like Session session = getSession(); Criteria crtP = session.createCriteria(NotebookPageImpl.class); crtP.createCriteria("notes", "a").setFetchMode("notes",FetchMode.EAGER); crtP.addOrder(Order.asc("title")); I gets only those results which get matched in both tables. Please solve my problem as soon as possible....... Thanks in advance. Dinesh Gupta -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira