Code between sessionFactory.openSession() and session.close():
<Contact> contact = session.createCriteria(T1.class).add(Restrictions.eq("name", "Tom")).list();

Name and version of the database you are using:
mySQL 5

The generated SQL (show_sql=true):
select T1.property, T2.property, T3.id
from T1
left join T2 on T1.id = T2.id
left join T3 on T1.idd = T3.id

Question:
I do get only Criteria Examples which does have Criterions on just one table. I do have aan Entity T1 which has a Attribute (list<T2> t2list) with a List of Entities from Table T2 (in a one-to-many relation). How can I search for properties of this T2 Objects in the list with criteria?

Is there even a possibility to search for criterias on many-to-many-relations?
Example:
Entity T1 with a Relation to T1_T2 (only IDs) Objects
Entity T2 with a Relation to T1_T2 (only IDs) Objects

I want to search within my Criteria(T1.class) for a property of Entity T2 through Entity T1_T2.

Thank you very much

How to solve it:



My next problem: I cant search through 2 different many-to-many Relations:



The Criteria class tries to get the property3 Attribute from the T2 Entity. This attribute is in the T1 Entity... anybody got an idea?

I did solve it =) :