Hi,

I am new to hibernate and have a question. Its a simple one but dint find answers anywhere. I do a join and select 6 fields. The thing is that it goes on to the inner level.

"select distinct " +
"sc.componentVersion.component.name as cname, sc.componentVersion.component.description " +
",sc.componentVersion.version, sc.componentVersion.description " +
",sc.componentVersion.component.group.name, sc.componentVersion.component.group.description " +
"from Stack as s join s.stackComponents as sc " +
"where s.name = :stackNameQuery"



StackComponent has a foreign key reference to Stack Table.
StackComponent has a foreign key reference to ComponentVersion
ComponentVersion has a foriegn key reference to Components.
Components has a foriegn key reference to Group.


Now my question is when i execute the above query i get a List of Object objects. How do i get the actual values of sc.componentVersion.componentName and other fields?

Its really very urgent. I would be really grateful if somebody help me out.

Thanks in advance

I think it's an object array. Each list entry is one row of results, and the object arrays contain the data which you can cast to String or Byte or whatever.

Hi,

Yeah your right. I get an Object array. But i am not able to cast the Object object into any other type. I tried casting it to string since name is stored as string in database.

I found a solution for this. Its to create a new DAO class for that query and make the query return array of objects of that type. But can somebody help me in using the Object type returned.