I'd like to use hibernate with annotations to run a rather complex native query and map the results to a tree of entities (a root object, with 1...n children, etc) . It looks like @SqlResultSetMapping is the direction I should go (for mapping entities to query results, instead of individual tables), but although it looks easy enough to map the columns in the result set to fields in one or more entities, I don't know how to set up the mapping between the (flattened) result set and the tree-like structure of the entities. Is this possible? I'm new to hibernate and EJB3, so if anyone can point me in the right direction, I would very much appreciate it!

Thanks,
Tim

Why don't you use HQL?

Thanks for the reply, but I'm not sure how HQL gets me around the problem...Essentially, I want to map a tree of objects to the results of a query (rather than individual tables-- the query is rather complex and actually joins together 10 or so tables, and has columns representing results from stored procedures, etc). I don't care whether the query is an HQL or SQL query; I just need to know how to set up the mapping. As I mentioned, I am new to hibernate, so perhaps I'm missing something obvious...

Thanks,
Tim

the number of joins is not an issue for HQL (actually usually it's more redeable), the stored proc is a issue though.

In your case I guess you'll have to use an hbm mapping to map your native query. EJB3 is not as flexible as Hibernate here.