*
The moose likes Object Relational Mapping and the fly likes Join query in hql causing IllegalStateException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Join query in hql causing IllegalStateException" Watch "Join query in hql causing IllegalStateException" New topic
Author

Join query in hql causing IllegalStateException

Gopakumar Naryanan
Ranch Hand

Joined: Jan 15, 2011
Posts: 72

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.


Thanks & Regards
Gopakumar
 
Don't get me started about those stupid light bulbs.
 
subject: Join query in hql causing IllegalStateException
 
Similar Threads
Derived Property issue in Hibernate
using aliases
Invocation of init method failed; nested exception is net.sf.cglib.core.CodeGeneration
Confusion when joining two tables
Hibernate config issue