Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to avoid cross join from hibernate generated sql

 
Robo Fazak
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,


I am trying to execute a HQL query



Hibernate generates the following query



that causes the error in oracle : ORA-25156: old style outer join (+) cannot be used with ANSI joins

Please suggest a solution for this. I don't know why hibernate generates a cross join automatically.







 
Bill Gorder
Bartender
Posts: 1682
7
Android IntelliJ IDE Linux Mac OS X Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is more than one Oracle Dialect are you using the correct one?
http://docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/dialect/package-summary.html

Are you using the correct JDBC driver for Oracle? What version of Oracle and Hibernate are you using?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic