posted 11 years ago
Hi All,
Anybody please tell me How to create a HQL from Oracle View?
EMPLOYEE_VIEW
create or replace force view "ROOT"."EMPLOYEE_VIEW" ("seq_id","first_name","last_name",) as
select
employee.seq_id as "seq_id",
employee.first_name as "first_name",
employee.last_name as "last_name"
from employee employee
left join lookup_data lookup
on lookup.cat_id = employee.designation
EmployeeView.xml
EmployeeViewDto.java
I would like to map Above class to EMPLOYEE_VIEW , can I write the HQL?
I have done in following way but it is not working
Here Exception is coming...
Please tell me any solution.
Thanks,
Aby