hi all,
this is my sql query. Can anybody please write a HQL query for the same. This is very urgent. Thanking in advance.

SELECT DISTINCT os.acttype , os.objectid , sa.usecount
FROM studact sa
RIGHT OUTER JOIN objset os ON sa.studid = 12249

this is how i ported it to hql

select distinct os.ObjectId , sa.UseCount
from StudAct as sa
right outer join sa.ObjSet as os where sa.Student=12249

but this is giving me different results than the sql query. sql query is taking a cartesian product and somehow hibernate is not doing it.

please help me.

Your SQL Statement isn't joining on any columns which is why you're getting the cartesian product. The HQL is joining on the key column.

You HQL is doing a join on the key column, then filtering on student 12249.


Are you sure the SQL is what you really want ? Can you show your table definitions ?

i am porting the procedures which are there in sql to hibernate so i dont have much freedom to change the sql. i have to just port it to hql and yes the sql is correct. i have to get the same results using hql that i am getting using sql. so please help.

sorry the sql query was

SELECT DISTINCT os.acttype , os.objectid , sa.usecount
FROM studact sa RIGHT OUTER JOIN
objset os ON studid = 12249
AND os.objectid = sa.objsetid

please help me porting this query to HQL