Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate criteria for left outer join

 
amarshi mohanty
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
Please help me in converting the below query in Hibernate Criteria.
select * from TABLE1 tr left outer join TABLE2 trd on trd.releasekey = tr.pkey where tr.projkey = " PROJKEYVALUE

I referred in web , using 2 createCriteria(),createAlias()..but nothing is working.


Thanks
Amarshi
 
Raza Mohd
Ranch Hand
Posts: 247
Java MyEclipse IDE MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

You can use fetchMode for Join.

 
amarshi mohanty
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Raza Mohd wrote:hi,

You can use fetchMode for Join.



Please post any code snippet.


Thanks
Amarshi
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic