Hi.

I have two objects which one of them is Person.class, and another one is PhoneNumber.class.
There is a relationship between Person and PhoneNumber and a person may have more than one phonenumber. Their relationship is linked with this;



Now, i want to get PhoneNumber list from Person using Criteria. But i couldn't find a solution about this. The important thing is that i want to get List of PhoneNumber, not a Person.

And this is the Person.class



How can i get this?

Thanks for any help.

Hi,
I dont know, whether i ve got your question right?
But i m trying to answer your query based on some assumptions.

try the following code.

Criteria criteria = getSession().createCriteria( Person.class ); // i ve extended the HibernateDaoSupport class.
criteria.add(Restrictions.eq("id",1234));
criteria.add(Restrictions.between("hiredate", '05/05/2004', '05/10/2004');
List persons = criteria.list();

now you will get all the persons matching the above criteria in the persons list.

Person person = (Persons) persons.get(0);
System.out.println(persons.getPhoneNumbers()); //override the toString method in PhoneNumbers class to display the phone numbers.

i hope it helps.

if not, i ve not got your question correctly.

Hi. Your solution is true but there is a problem about it.

This criteria gets person and i get phonenumbers over it. When this method ends i have a phonenumbers list, but the person object still wait on the session and if i want to delete phonenumbers from where i call it like bean i get an error. Because of this i want to get phonenumbers list directly from criteria. I may get a list of property with type string, long, date etc but i cant get collections over criteria.