This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Join query in hql causing IllegalStateException  RSS feed

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.
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!