Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hi All

I have the following objects

House {
String name;
Set persons;
.
.
.
}

and

Person {
String name;
Integer age;
.
.
.
}

each house can have a set of 0 or more persons, but there are some persons that doesn't belong to any house. I need a query to select all houses that contain persons with age<20.

I tried:

from House as h
join h.persons as p
where p.age<20

It doesn't work. What's wrong? Please help!!!!

thanks,
piri

p is a collection, not a person

next time don't add '!!!' in your subject

Thanks Anthony,

is there a posibility to search thru elements of a Collection?

I saw this in Hibernate documentation:

select account, payment
from Account as account
left outer join account.payments as payment
where :currentUser in elements(account.holder.users)
and PaymentStatus.UNPAID = isNull(payment.currentStatus.name, PaymentStatus.UNPAID)
order by account.type.sortOrder, account.accountNumber, payment.dueDate

In this example payment is a collection of payments? I see a property of payment is accessed (payment.currentStatus.name).

Am I missing something?

thanks
piri

check in elements() keyword in reference guide

Hi,

my question is if it's possible to access, in where clause, a property of an item from a collection kind property???

piri

Also I tried the following query:

from House as h
where ( select count(*) from h.persons as p where p.age<20 )

and I got some strange kind of objects? What is wrong? Anyone, please help!

thanks
piri

Also I tried the following query:

from House as h
where ( select count(*) from h.persons as p where p.age<20 ) > 0

and I got some strange kind of objects? What is wrong? Anyone, please help!

thanks
piri

from House as h
join h.persons as p,
Person person
where person.age<20
and person in elements(p)


in in elements, i said....

Hi,

This solutin didn't work, I got an QueryException, then I chenge the query to

select h
from House as h,
Person person
where person.age<20
and person in elements(h.persons)

which makes sense... an I get a few objects of class House$$EnhancerByCGLIB$$56a42fa which contains tha attributes of House class but with null values. very strange! how can I obtain the real House objects with needed condition??? Is this to hard for hibernate?

piri

Is there something wrong with the documentation?

Jesus guys, maybe is something wrong with me, but please help me to understand what is happening....

thanks

You are getting proxies, a very normal thing. Please start reading.

I'm sorry, but I read the documentation and I didn't see anything about proxies, at least in the HQL chapter....

If you want House objects you must select only House objects.

So you're on the wrong page. You query must start with
"from House as house where" .

If your Person object has a reverse lookup House member
something like the hql below will.

Although there are probably better ways to do it.

Anyone ?

from House as house
where
house.house_id
in ( select person.House
from Person person where person.age < 20 )

you can also hit the proxy (for example System.out.println(myObj.getProperty()) to see what happen.