• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can we execute sql query with outer join in hibernate

 
MaheshS Kumbhar
Ranch Hand
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can we execute a native sql query with "outer join" clause using hibernate?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can execute any SQL you like using the native query methods. Generally native SQL is the last resort though, since it carries its own penalties. Outer joins are supported in HQL, so you shouldn't need to resourt to native SQL to do this.
 
Kaustubh G Sharma
Ranch Hand
Posts: 1283
Chrome Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes you can do it
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic