Hi All

I am using Hibernate version 3.0
This is the SQL query I have
**********************************
select obj.id, obj.name from obj, r_obj,r, usr
where obj.id = r_obj.id and r_obj.r_id = r.r_id
and usr.u_id='testuser'

**********************************

I have 2 rows in my obj table which i want to retrieve based on the above query.

So i tried to create this HQL equivalent of the above SQL as a named query
**********************************

<query name="objq"><![CDATA[
Select obj from Obj as obj
inner join obj.rObj as rObj
inner join rObj.role as role
inner join role.users as user
user.userId = ?]]></query>
**********************************

But the problem with the above HQL named query is its returning me only the 1st row of the obj table twice & not the 2 independent different rows which are in my obj table

Can some let me know what is wrong in this HQL



Regards

Providing your many-to-one mapping are working between objects:



A wild guess at the HQL.