Gopakumar Naryanan

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!


<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.hibernate.practice.model.Employee" table="emp"> <id column="empno" name="empno" type="long"> <generator class="increment"/> </id> <property column="ename" name="ename" type="string"/> <property column="job" name="job" type="string"/> <property column="mgr" name="manager" type="long"/> <property column="hiredate" name="hireDate" type="date"/> <property column="sal" name="sal" type="big_decimal"/> <property column="comm" name="commision" type="big_decimal"/> <one-to-one name="grade" class="com.hibernate.practice.model.Salgrade" /> <set name="subOrdinates" cascade="all" table="emp"> <key column="empno" not-null="false"/> <one-to-many class="com.hibernate.practice.model.Employee" /> </set> <many-to-one name="dept" class="com.hibernate.practice.model.Department" column="deptno"/> </class> <query name="employees-with-more-experience-than-their-mnagers"> <![CDATA[select distinct(e) from Employee as e join com.hibernate.practice.model.Employee as e1 where e.empno=e1.manager and e.hireDate > e1.hireDate ]]> </query> </hibernate-mapping>

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 :
<query name="employees-with-more-experience-than-their-mnagers"> <![CDATA[select distinct(e) from Employee as e ,Employee as e1 where e.empno=e1.manager and e.hireDate > e1.hireDate ]]> </query>

It works fine.


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

Thanks in advance.

Thanks.. i didn't notice the spelling mistake you specified.

Please check your User class.. is there any specific requirement that it should extend ActionSupport class?
I have not worked on Struts 2.. but i haven't seen anywhere one action class being instance variable of other..

[b]<c:forEach var="variable" items="${abab.custid}" > <% System.out.println("Hellojjsdsd"); %> <option value="${variable.AccountID}"></option> </c:forEach>[/b]

I think you need to make a correction here :

<option value="${variable.AccountID}"></option>

In the above code variable itself holds the "AccountId".. so please change it as follows:

<option value="${variable}"></option>

Hope it works fine.

Appreciate your spirit .. Wish you all success .. Keep up the good work.

This could be problem with antlr jar file try using appropriate version.
Please go thru the following link :

https://forum.hibernate.org/viewtopic.php?p=2435893

This link could solve the issue.

Please make sure you have all the required jar files in your buildpath. It seems you are missing a jar file related to ehcache. Please check.

Try using hidden form fields for non-editable fields .. and keep the rest as they are.. hope this works fine for your requirements .

<a href='${formBean.property}'>link</a>
Please try this..

<c:choose ><c:when test='${user} eq 'user '>edit/delete grid</c:when ><c:otherwise>view grid</c:otherwise></c:choose >
I am not sure whether you are expecting something internal to grid.

<HTML:text property='name' value='${emp.name}></html:text> where property is your formbean property and value is what you were trying to put in bean:write tag emp is bean name and name is the property.

You can use <c:import> tag for this task.

Does it make any sense using jstl tags like <c:choose ></c:choose> TAGS?

Please share the code or stacktrace you are getting when you run the app.

Probably this issue must have been resolved . Only change you require is your DTO object that is MyModel class must follow Java Beans naming conventions.
Please use code tag for better readability of the code.