I have 2 tables PARENT and CHILD. The PARENT tabel has a foriegn key to the CHILD table. I want to query for all children of parent with ID = 1

select p.child from Parent p where p.id = 1

The above query returns proxies for the children. How can write the same query with the collection been intitialized?

Thanks

Sounds like you want your collections eagerly fetched.

You can try setting lazy=false in your mapping file.

I'm not sure if that will work with the query that you have though but if you have, for example



When you do p.getChildren() you should get an initialized collection.

use "fetch" join to get childern using single select statement.


refer section 11.3 from http://www.hibernate.org/hib_docs/refer ... ryhql.html

I thought of that, however I want to keep the default setting - lazy true- and overrite the settings per query bases.

In addition: it is not one-to-many relationship. It is many-to-many. The child and the parent form a composite key.

It is not a one-to-many relationship, it is many-to-many. The child and the parent form a compoist key.

select p.child from Parent p left join fetch p.child where p.id = 2

the above query will throw an error.

however this query will not throw an error

select p from Parent p left join fetch p.child where p.id = 1

The above query will return a list of parent objects with its child object initialized. How can I return the child objects only?

why don't you just query for the children.

from child c where c.parent.id=1

or subselect

from child where c.parent in (select parent where id=1)

I have observed that parent.getchildren() does not lazily load the children but any call to getChildren().size() or getChildren.iterator() initiates the lazy loading.

Can someone confirm if this is the expected behaviour or I can get the children loaded with a call to parent.getchildren() itself?

is what you want to do with the session still open.





another way is to specify a join fetch on the children with an hql query.