Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to use right outer join Hibernate

 
vamshidhar nimbagiri
Ranch Hand
Posts: 61
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i have situation to move DAO to hibernate ... the SQL query which we were using previously is

select slc.firstName, slc.lastName, slc.status, slc.email,
d.state, slc.contactID from SalesLCt slc,
ddr d
where slc.addressID *= d.addressID and slc.status = 'Active' and
and upper(slc.firstName) + ' ' +
upper(slc.lastName) = ? order by slc.lastName, slc.firstName

could any body plz tell me how to write the same in Hibernate?

Thanks in Advance,
vamshi
 
Scott Johnson
Ranch Hand
Posts: 518
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Section 14.3 of the Hibernate manual discusses HQL outer join syntax with examples.
[ January 20, 2006: Message edited by: Scott Johnson ]
 
vamshidhar nimbagiri
Ranch Hand
Posts: 61
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic