hello all.
I was hoping that someone could bounce ideas with me.
I need to create query. Ultimately, I need a "parent list".
I have a tree-like structure with id and parent id. I have a result set list already with id and parent id (if there is one).

For example: from subtree 1 result set to contain 1,3


For example: from subtree 1 result set to contain 6, 8


After finding the top level I will execute a query based on the subtree and build a result set to be returned after the for looping.

Any ideas appreciated.

You're talking about result sets as though you're dealing with JDBC statements. There's no way to understand from your description what you really want.
I suggest you study Chapter 7 "Collection Mapping" from the Hibernate reference, and then search out references to the term "parent-child". It's a fairly standard Hibernate pattern, and has nothing to do with result sets.
Hope that helps.

I am at the DAO level and I am writing my own HQL queries. My hibernate mapping is already working correctly. I don't want to return the entire class. I am trying to work with selected fields only and I don't want to work with data-transfer classes for each query.

Erm, a class (or object of that class) is an atomic unit. Definition of "atomic":



What you are saying still makes no sense to me. It does not seem sequiteur to me.
If you want help you need to communicate the concept in your mind so that arrives in the other guy's mind without confusion.

I think that you are thinking in terms of "data" not in terms of "objects". My only suggestion can be to re-visit the design of your object model, because it seems it is not doing naturally and easily what you need from it. If I am being patronizing then I apologise, and have no more to say.

I'm having trouble following as well.
Maybe if you showed your Class, mappings, sample code - or a scaled-down example of them.