Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Hibernate criteria for left outer join  RSS feed

 
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
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!