Left Join

jitheshm · **Joined:** Mon Jul 11, 2005 12:33 am **Posts:** 2

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3

HQL as I 've done
FROM PMSProjectsORO pjt LEFT JOIN PMSChecklistORO pcl ON pjt.projectId = pcl.projectId order by pjt.projectCode asc

Original SQL for MSQL5:
FROM PMSProject LEFT JOIN PMSCheckList ON
PMSProject.PROJECT_ID = PMSCheckList.PROJECT_ID order by PMSProject.PROJECT_CODE desc
Name and version of the database you are using:
MYSQL 5

Please help me convert the sql to hql since what i 've done is throwing error like unexpected token... Please reply ASAP

Read this: http://hibernate.org/42.html

CWitherow · **Posted:** Thu Sep 07, 2006 10:08 am

There is no "ON ..." syntax in HQL -- the association is defined in the Hibernate mapping files.

So, HQL would be something like

Code:

FROM PMSProjectsORO pjt LEFT JOIN PMSChecklistORO pcl ORDER BY pjt.projectCode ASC

jitheshm · **Joined:** Mon Jul 11, 2005 12:33 am **Posts:** 2

No mapping is done between these tables... I need to know how can we acheive the same with out a mapping defined. ie it should completely come from HQL...

Still i've tried the same what u 've suggested... but gave an error:

org.hibernate.hql.ast.QuerySyntaxException: Path expected for join!

Please help me resolve this..

CWitherow · **Posted:** Thu Sep 07, 2006 10:36 am

SORRY, this will only get you an inner join.

You need mappings to use HQL. If you have mappings but no relationship, you can use the syntax of:

Code:

FROM Object1 obj1, Object2 obj2 WHERE obj1.prop1 = obj2.prop2

to acheive a "join".

You could use native SQL within Hibernate.

Curtis ...