Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

hibernate left join not working

 
Pranav Sharma
Ranch Hand
Posts: 258
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 518
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do your mapping files have an association defined between objects table1 and table2? If not that could be your issue.
 
Lucian Ochian
Greenhorn
Posts: 7
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic