Hello All,

I have a query like

Select P.name,subresult.f2,subresult.f2
(select f1,f2,f3 from pojo1 p1,pojo2 p2
where p1.f4=p2.f8) subresult , pojo3 P
where subresult.f3=P.f1

1) How to write the same in HQL

2) How to call a view ? in HQL

Can any body assist on this.

Thanks

1) There is no from-clause in your outer-query. That doesn't seem right.

2) You can map an entity to a view so that you can use this entity in HQL.

Hi

My query is missing the keyword "from" and is


Select P.name,subresult.f2,subresult.f2
from
(select f1,f2,f3 from pojo1 p1,pojo2 p2 where p1.f4=p2.f8) subresult ,
pojo3 P
where subresult.f3=P.f1

1) can you tell me how to write using HQL
(Here we are comparing subquery result with some other class object)
(how do I refer/name subquery result )
2) Can anybody give me example for mapping entities with views using HQL

I'm sure there are many posts in this forum to map a Database View to an entity.

in your case you need to create a database view
create view subresult as
select f1,f2,f3 from pojo1 p1,pojo2 p2
where p1.f4=p2.f8

create a POJO which will have the setters and getter's matching the column names and

create hibernate .hbm file describing the mapping from database view to POJO.

Then in HQL:-
Select P.name,subresult.f2,subresult.f2
subresult, pojo3 P
where subresult.f3=P.f1

see this as reference:-
http://forum.hibernate.org/viewtopic.ph ... highlight=

hope this helps,
Latha.