Hi All,

I want to display parent table columns and one child table column

example:
parent table
Customerid, customerName,

child table:
itemId(from child table) one customer can have many itemId.


When you use lazy="false" it affects the performance.

how can i get the child column even though lazy="true"

how will you load child objects when you execute hibernate query when the lazy="true";

my query returns list of parent rows. i need to get child column for eacn parent row...

how to get the child column without affecting the performance?

If you don't mind a little bit of java awkwardness, you could use this concept:When you run that HQL, hibernate can detect that id (which is itemId) is in the parent table, and won't even do the join! The thing you get back from that query will be an Object[2], so you'd use java code like this:

can i use mapping xml files for these???

You can define the query in your mapping file. You can also create a bean-type object from the results, if you want:Then you just need to create the CustomerAndItemId class. You don't need to map it anywhere, instances of it will be created by hibernate: the "select new" syntax does that.