Multiple object return in a query

[binario]

Hi all,

I would like to know people's advice for returning more than 1 object from a query. For example, lots of web pages want to display info from more than 1 table. Example: display a company and its list of employees on 1 page. Now most of the examples I see for ejb3 query language return things like Company or Employee, but the real world problems I see need to get back custom information - can anyone tell me how to do this?

thanks very much,
Binario

[bill.burke]

Try projection...It should work:

public class Report
{
 String first;
 String last;

 public Report(String first, String last) {...}

}

select new Report(c.first, c.last) from Customer c;

Or, I think if you don't project, you can query columns and you'll get them back in a List object.

Bill

[binario]

Thanks for the reply Bill.

I'll check it out

If you also know when support for blobs and webservices are expected I'd love to know

[bill.burke]

webservices not for a long while...We're dependent on the new JAX-RPC specification for that.

Blobs/clobs, seems like its needed so I'll see what I can do.

Bill