How to create a entity class in this case

peterleonard · **Joined:** Wed Mar 29, 2006 11:54 pm **Posts:** 4

Hi

How can i create an entity for a query like below

select t1.name as F!, t2.salary as F2, t1.city as F3, t2.total as F4 from tra_emp t1, tra_salary t2 inner join ref_feature t3 on t1.empid = t3.empid

Regards

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Can you rephrase your question? Do you already have a class, and you want to create an instance of it from an arbitrary piece of HQL or SQL? Also, can you correct your query? There's no relation between tra_salary and any other table, so that query is going to produce a full cross-join, and I very much doubt that that's what you want.

But briefly, assumng that you've mapped your classes and so on, the sort of HQL code you're looking for is

Code:

select e
from Employee e
join e.Feature f
where e.Name = :Name