Anybody please tell me How to create a HQL from Oracle View?
create or replace force view "ROOT"."EMPLOYEE_VIEW" ("seq_id","first_name","last_name",) as
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
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
Please post any exception you are receiving. Are you trying to replace the view with a query against the tables that make up the view or are you trying to use the view in your query? If it is the latter a view would be treated the same as a Table.