• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Join query in hql causing IllegalStateException

 
Gopakumar Naryanan
Ranch Hand
Posts: 72
Eclipse IDE Hibernate Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was trying to display employees who has more experience than their manager using HQL. This is the Exception i'm getting when i try HQL query using joins

Exception in thread "main" java.lang.IllegalStateException: DOT node with no left-hand-side!




Note : I added fully qualified in the join query to avoid the below Exception
org.hibernate.hql.internal.ast.QuerySyntaxException: Path expected for join!

When i modify the query as follows :


It works fine.


would like to know where i'm doing mistake.. Any suggestion is greatly appreciated.

Thanks in advance.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic