File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Join query in hql causing IllegalStateException
 
Similar Threads
using aliases
Hibernate config issue
Derived Property issue in Hibernate
Invocation of init method failed; nested exception is net.sf.cglib.core.CodeGeneration
Confusion when joining two tables