It's not a secret anymore!
The moose likes Object Relational Mapping and the fly likes hibernate left join not working Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "hibernate left join not working" Watch "hibernate left join not working" New topic

hibernate left join not working

Pranav Sharma
Ranch Hand

Joined: Oct 27, 2003
Posts: 258
I use the following query in Hibernate for a left join between table1 and table2.

Can someone help me with this.
[ October 21, 2005: Message edited by: mannu kapoor ]
Scott Johnson
Ranch Hand

Joined: Aug 24, 2005
Posts: 518
Do your mapping files have an association defined between objects table1 and table2? If not that could be your issue.
Lucian Ochian

Joined: Nov 23, 2004
Posts: 7
The way that you wrote the query it seems to be an SQL query and not an HQL query.
Using session.createQuery, you need to provide to this method a HQL query, and not a SQL query.
You can use session.createSQLQuery with a SQL query, or write your query as a HQL query, something like:

select cv.field from table1 alias1 JOIN alias1.x alias2, where x is your association element in the first class.

Hope this helps!
[ November 16, 2005: Message edited by: Lucian Ochian ]
I agree. Here's the link:
subject: hibernate left join not working
jQuery in Action, 3rd edition