java - How to fetch data from joined tables straight to a class? -

is possible retrieve data query straight employeeform?

query stored procedure empdata

select a.name,b.username,b.password tbemployee left join tbuser 

code

   list<employeeform> form = new arraylist<employeeform>();     empdb service = (empdb) runtimeaccess.getinstance().getservicebean(     service.begin();     session session = service.getdataservicemanager().getsession();     sqlquery query = session.createsqlquery("exec empdata");     list list = query.list();     formlist = list; 

this gives me error:

java.lang.classcastexception: [ljava.lang.object; cannot cast com.emp.form.employeeform 

you need use resulttransformer

the other option cast list<object[]> contains rows columns query result, , iterate , extract data(more work).

the transformer like:

query.setresulttransformer(transformers.aliastobean(employeeform.class));