hi,
Im a newbie with hibernate. I must invoke the createquery method to fill query result into an array. my code is as follows

protected Vector getResultArray(Session session, String query){
...
Vector vec=new Vector();
Transaction tx=null;

try
{
tx = session.beginTransaction();
vec=new Vector(session.createQuery(query).setReadOnly(true).list());
tx.commit();
}
catch (Exception e)
{
if (tx!=null) tx.rollback();
.....
}
return vec;
}


and this is the query passed to it

String query="select f.surname, f.name, f.code from Employees as f " +
"where f.code in (" +
"select distinct(i.code) from Employeeroles as i " +
"where i.descrole <> 'EMPLOYEE') " +
"and (f.name like '"+filter.toUpperCase()+"%' or f.surname like '"+filter.toLowerCase()+"%')" +
"order by f.surname, f.name";

when I call getResultArray(session, query) I get this error

could not resolve property: code of: [select f.surname, f.name, f.code from [path.to.database.]Employees as f where f.code in (select distinct(i.code) from [path.to.database.]Employeeroles as i where i.descrole <> 'EMPLOYEE') and (f.name like '%%' or f.surname like '%%') order by f.surname, f.name]

where is the error? I tried to run query and it works. Please help

You can't write:

write simply:


Please, don't forget to rate.