Hi,

I am having a hard time to write the HQL for this senario

I have two classes Form and FormVersion. Form has a unidirectional one-to-many relation with FormVersion.
FormVersion has all the attributes of the form like name, description, ...
If i want to retrieve a form attribute i have to do form.getFormVersions() which returns a collection of FormVersion objects then, retrieve the attributes of the FormVersion objects.

My problem is i have to write a HQL query for findByFormName() passing the formName parameter. How can i find formName in collection of formVersion objects ( form.getFormVersions() )

anybody guys please help!

Hi,

why not to use a named queries?

Take a look at http://www.hibernate.org/hib_docs/refer ... ting-named

Or I understand your requirement not correctly?

if you give me ur sql, i can give u corresponding hql ? by using hql only u can get the things that u want. I don't know y r u going for that many things ?

javri28,

Yeah I can use named query. But i dont know how to build the query for this requirement.

gopal.knoah ,

My sql looks like this

select * from form f join form_version fv on f.oid=fv.form_oid and fv.name='name version1';

form table form_version table
------ ----------------
oid (pk) oid (pk)
form_oid (fk)
name
.........

The relation is one-to-many

Hi,

what about something like this:

from packagename.FormVersion as formVersion left outer join formVersion.form as form where form.name := ?

In your form_version table, I think form_oid is pk and oid is fk
check it once. I m doing like this.....ok

try in this way now.
Hql :
FROM FormBean F
JOIN F.fv AS formFv
AND formFv.name = 'name version1'

Now go to FormBean.hbm.xml and put this mapping
<many-to-one name = "fv" class = "FormVersionBean" column = "oid" insert = "false" update = "false" />

Now go to FormBean.java and add this field
private FormVersionBean fv;
create its getter and setter

make show_sql true and see the sql at the console converted from this hql. u will get the same sql as u had given to me.

Thanks,
Gopal
[please rate, if helpful]