Hi all


We are facing a problem on retreiving the results on hierarchical queries

We use hierarchical queries in our application . since hibernate does not support any of these queries we are firing native sql queries


This is our query
select pth_pty_party_id, PTH_PTY_PARENT_PARTY_ID, level
from party_hierarchy where PTH_HRC_SUBTREE_ID='H10'
start with pth_pty_party_id='110204'
connect by pth_pty_party_id = prior pth_pty_parent_party_id

Now the level selected is an oracle kyword and not a table column ...
Ths is what this query would return.

PTH_PTY_PARTY_ID PTH_PTY_PARENT_PARTY_ID LEVEL
---------------- ----------------------- ----------------------
110204 110203 1
110203 110202 2
110202 110201 3
110201 4


4 rows selected



How can we retrive the level value in our java code ... Since there is no mapping in our mapping fiile the resulting objects will contain values only for the columns mapped.

basically is there any equivalent for resultset in Hibernate ?

read this blog for info on how to use ResultTransformers for HQL and SQL:

http://blog.hibernate.org/cgi-bin/blosxom.cgi/2006/03/17/

thanks a lot. That was indeed of great ehlp.