File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes HQL Self Left Outer Join Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL Self Left Outer Join" Watch "HQL Self Left Outer Join" New topic
Author

HQL Self Left Outer Join

Prem Kash
Greenhorn

Joined: Dec 04, 2007
Posts: 5
I want to have a self Left outer join on the table using HQL(Hibernate Query language), can anybody please help...

Here are the classes




And I wanyt to implement the following query using HQL or Criteria Query, can anybody please help.

select j1.job_item_id, j2.job_item_id, j1.job_item_status,j2.job_item_status from tt_job_item as j1 left join tt_job_item as j2 on j1.locked_item = j2.locked_item


Hope to get response soon,<br />Thanks,<br />Prem.
Devaka Cooray
ExamLab Creator
Saloon Keeper

Joined: Jul 29, 2008
Posts: 2885
    
  13

Please UseCodeTags


Author of ExamLab ExamLab - a free SCJP / OCPJP exam simulator
My Home Page -- Twitter Profile -- JavaRanch FAQ -- How to Ask a Question
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: HQL Self Left Outer Join
 
Similar Threads
Can a class be mapped to a table and be Embeddable at the same time?
Hibernate SELF LEFT OUTER JOIN
problem with using idbags in Hibernate, which gives persistenceException etc. Help please. Thanks!
Problems using GenerationType.IDENTITY for in-memory databases
JPA - need help with query