Hello,

Hibernate 3.0.3

Oracle 9i

I used the following native sql query and i got the expected results.



***
a)objective_uid in OBJECTIVE_RESULT_BT table represents a foreign key(MANY-TO-ONE from OBJECTIVE_RESULT_BT to OBJECTIVE) for objective_uid primary key column in OBJECTIVE table in database

b)result_bt_uid in OBJECTIVE_RESULT_BT table represents a foreign key(MANY-TO-ONE from OBJECTIVE_RESULT_BT to RESULT_BT) for Result_Bt_Uid primary key column in Result_Bt table in database


But when i converted the above SQL query to HQL query as mentioned below :



I got the following error :
Unxpected token : ( line 4, column 1

What i am guessing is that because temp is not at all related to any entity(as it doesn't exist) this error may be coming.Am i correct??
If yes then how can i make use of the concept i used in the native SQL query to get the desired results, in HQL??

Regarding the same problem i tried another HQL query as mentioned below:



When executed the above query i got the error : "Path expected for join!" .

What does this error indicate and how to resolve the same????

Please comment on the above mentioned queries..

Thanks

Check for you sub query and likewise perform on the full query... ok
This is your sub query

select distinct orbt.objective.pmcId
from ObjectiveResultBt orbt inner join ResultBt rbt on orbt.resultBt.pmcId = rbt.pmcId
where rbt.metricMeasurementPeriodType.measurementTypeID <= :lgm_Id


SELECT distinct orbt.objective.pmcId
FROM ObjectiveResultBt orbt
INNER JOIN orbt.some_x_name_for_ResultBt as somealias
where somealias.measurementTypeID<=:lgm_Id

now add the given mapping to hbm of ObjectiveResultBt
<many-to-one name="some_x_name_for_ResultBt" class="ResultBt" column="pmcId" property-ref="pmcId" insert="false" update="false" />

and make getter and setter for ResultBt in pojo class ObjectiveResultBt with some_x_name_for_ResultBt name.

try this way. It should work

Thanks,
Gopal

[If Helpful, please rate]