Hello,

I am facing a problem while implementing searching for a many-many relationship. I am giving the scenerio:

I have a Document object and some of the categories. Any document can lie in one or more categories. So I made a separate table for categories and used a relation table between document and category, to implement many - 2 - many relationship between these two. So now, document object has a collection of categories.

Document -----0..* document_category*..0-----category

Now the requirement is, that I have to search document based on its categories type, which can be more than one.

This can be achieved in a way like:

We can get all the document from document_category table based on passed categories types using intersect clause.

So first I want to know that, can we use intersect clause in hibernateQL.

and second, is there any better approach for this scnerio .. means for searching documents based on its category collection parameters.

It is urgent, please reply asap.

Thanks delpouve,

This can work for me. I will try it.

Still I have a problem here. Actually based on criteria that I have for category object, I can get more than one object. Like requirement is like,

select document which contains categories having name a and b.

there is and condition required.

so how can I achieve this using HQL. As we can't apply both conditions on same object at the same time ie

select doc from Document doc, Category cat
where cat.a = myCriteria and cat.a = myCriteria1
and cat in elements (doc.cats)

---------------------

another method can be if I can check any of the property of list elements like

select doc from Document doc, Category cat
where myCriteria in (doc.categories).name &&
myCriteria1 in (doc.categories).name


Please suggest for it. It is very urgent.

Thanks