hello,


How can i query an associated object with the ".add" method after a ".createCriteria" ?
I see in the sql output that the object is initialised but i still dont know how to access an attribute from the associated object.

Hi chuanito,

For example

Criteria criteria = session.createCriteria(XYZ.class);
criteria.add(Restrictions.eq("xyz", abc));
Criteria criteria2 = criteria.createCriteria("pqr");
criteria2.add(Restrictions.eq("pqrProperty.index", "443"));



Class XYZ
{
List pqr
}

Class PQR{
RST pqrProperty;
}

Class RST{
String index,
}

I have a related problem. In the example dharmendra gave below, assume class XYZ stored a single object of class PQR instead of a list. Then assume you have two sublcasses of PQR: ABC and DEF. My question is how to use criteria to find all XYZ objects whose PQR member variable is of type ABC.

That is, given the following relationships,



how do I construct a criteria query to return all XYZ objects where pqr is of type ABC?

A simple real-world example is an item and bid construct. Assuming items have categories like Electronics, Books, Music, that are all subclasses of a master Item class, and assuming that each bid stores a reference to an item, how could you find all bids for Electronics items?

Thanks,
Jacob

hi vitasthefetus,

if you have used sub class mapping by discriminator ,Try to map that column with read only property insert false update false. Then apply the criteria on that property. This might help not sure.

Thanks for the suggestion. I am using subclass mapping by discriminator, and I tried insert=false but it didn't help. Please let me know if you have any other suggestions. This seems like it would be a common problem -- maybe the solution is to frame the query in a different context? Any help will be greatly appreciated.