hibernate hsql getting error No data type for node: org.hibernate.hql.ast.tree.IdentNode

hibernate, hsqldb, java

Solution

What's e doing in `Select e from ....`? Try changing it to `e.OrderLocation` or `*`.

Check this link for examples.

Problem

I am getting an error in my hsql ``` No data type for node: org.hibernate.hql.ast.tree.IdentNode +-[IDENT] IdentNode: 'OrderLocation' {originalText=OrderLocation} ``` My Mapping class like this ``` <class name="core.classes.lab.LabOrder" table="lab_order"> <id name="Order_ID" type="int" column="labOrder_ID"> <generator class="increment" /> </id> <many-to-one name="TestID" class="core.classes.lab.TestDescription" fetch="join"> <column name="TestID" not-null="true" /> </many-to-one> <property name="OrderLocation" column="labOrder_Location" type="string" /> <property name="OrderStatus" column="labOrder_Status" type="string" /> <property name="DueDate" column="labOrder_DueDate" type="java.util.Date" /> <property name="OrderPriority" column="labOrder_Priority" type="int" /> <property name="OrderRemarks" column="labOrder_Remarks" type="string" /> <property name="OrderCreateDate" column="labOrder_CreateDate" type="java.util.Date" /> <property name="OrderCreateUser" column="labOrder_CreateUser" type="int" /> <property name="OrderLastUpdate" column="labOrder_LastUpdate" type="java.util.Date" /> <property name="OrderLastUpdateUser" column="labOrder_LastUpdateUser" type="int" /> </class> ``` and my hsql query like this ``` Select e from LabOrder as e,TestDescription as t where e.TestID =t.TestID and t.isSpecimenAvailable = true ``` can anyone tell me why i getting an error like this pls help me thank you

Original source