Hi

I've looked for this in the forum (and google, ..), but I have not found something that solves my problem. Maybe I cannot find the right thing, because I do not know what to look for.

I have following Problem (simplified):

Class A {

Set bs; //set of Bs
..

}

And I am searching for all As with several criterias.
One criteria (the problem) is that a property of B (of the Set of Bs) has a special value. For example the colour of B = 'red' or something like that.

when I try
..
criteria.add(Restrictions.eq("a.bs.colour", colour));
..

I reveive an hibernate exception that bs.clour could not be found.
I have also tried to make it a generic set like Set<B> bs; but this did not change the result..

Can anyone give me a tip?

Thank you very much

Best regards,
mcdot

PS.: many-to-many or one-to-many.. (both cases should be the same.. this example is rather one-to-many.. i am sry for the title)

no idea?

try to create an alias for bs and then do the query, something like this



hope this helps

thank you very much.. i'll try that.

it did not work :(

(A stands for a longer class name)

DetachedCriteria criteria = DetachedCriteria.forClass(A.class, "a"));

criteria.createAlias("a.bs","B");
criteria.add(Restricions.eq("a.bs.dateTime.time", value);

dateTime is an object that has some properties like time. So hibernate needs to check all the bs to find the correct value.

normal objects work fine. Maybe I can configure it that hibernate knows that the set of bs are from the Class B. Or do I need to join tables (hopefully not, because it would keep it much easier if I would be able to configure it)

maybe I haven't understood your tip correctly.

thanks ;)

best regards,
mcdot

maybe another tip or a tip to use it?

would be very nice, because I do not have so much experience with hibernate (it is my second smaller project with hibernate).

thanks a lot

mcdot