Hi

I have a one-to-many association to a class which is not mapped to any table.This association has to refer to a loader sql-query and populate the set.
How can I accomplish that in hibernate?

Thanks & Regs
Anand

using annotations and mapping the hibernate associations to the getter/setters rather than directly to a property, i have accomplished something similar by populating the pseudo-relation set when the setter for the related property is called.

alternately, if your DB supports views, you might consider creating a view with the query that you use to populate your pseudo-relation set and mapping the relationship to the view in hibernate.

Thanks for your answer.I tried with mappings by defining a query for collection loading.

Hibernate tries to execute the query when we access children lazily but the problem is how to pass parameters through mappings file.I do not want to call named query and pass params explicitly.

Any idea on how to do it?

Thanks