Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate Criteria Could not understand Left Join "ON" condition-- HELP

 
monika se
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have a Query on 2 tables A,B as below:

This query is returning correct result on Database.
select A.id, B.id from Apple A left join Ball B on A.id= B.aId where A.categoryId = 23 order by B.phone ;

In Database, for each category, We have many records in A table. And corresponding to each entry in A table, We may/may not have a unique entry in table B.
Need to fetch all records that are in A and are associated/not associated with Table B for that categoryId. When we do not find any record for B, make it as blank/null. Basically I want distinct entry left outer join.

When I am using it in Hibernate Criteria Class, on keyword is not recognized. And so not able to use it. Please suggest a way out to implement it.
Thanks.
 
Rajkamal Pillai
Ranch Hand
Posts: 445
1
Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

How are you specifying the JOIN condition with Criteria?

Cheers,
Raj.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic