Hi,

I have a class called Person. This class has a property called stateVisits like this:


A StateVisit would have a State property.

A State would have code and name properties.

Now I am trying to search for all Person(s) who have visited MD. In my Restrictions in my HibernatePersonDao, I use this, but it doesn't work.



It would throw me the error that it could not find property stateVisits.state.code in Person. Should it be
stateVisits.stateVisit.state.code instead? With the return type List<StateVisit>, it complicates things a bit for me.

Any help would be greatly appreciated it.

Johnny[/b]

Hi byteback.

it wont work with 3.1version.As for object modeling, If in DB 5 child record for one parent then retrieving it on some condition on child records, would cause in consistent hibernate session. Means that in session has let say on some condition has four record .If you are retrieving one parent with 4 child. But actually by association it should have 5.So to provide consistency to hibernate session they haven’t provided the filtering. Because other feature might effect like as cascade delete all orphan.

Try the following

String queryStr = "from Person as person where person.stateVisits.state.code = 'MD'";
Query query = session.createQuery(queryStr);
List<Person> = query.list();

Thanks