Hey all,

I didnt find this in search:

I want to select some field values in a plain old java object that I've defined as MyDTO. It has a constructor that accepts all the values I'm selecting and in that order:



The error I'm getting is org.hibernate.hql.ast.QuerySyntaxError: Unable to locate class [MyDTO] [

and then the trace, (run from Junit within Eclipse).
What gives here? I have my import set in the dao class just in case. The reason I'm doing it this way is to have a small and convenient class to package and potentially modify the values, and not full the full long fields which includes heavy objects like clobs.

Thanks in advance.

ok I think I've resolved this issue,

you aren't allowed to make it into a pojo, the class you select new as should be a pre-mapped hibernate class.

doh :\

if i have this wrong, please let me know, otherwise, time to dip back into the mapping files :\

No, you seem to have it right. It's basically the facade pattern, and you have to map both the parent and the child class as separate types.

I've done this same thing in my own apps to cut down on memory use when I really only want to fetch a few fields for an otherwise large and expensive object.

MyDTO does need to be a real class, with corresponding Hibernate mapping.

one final note, this was way easier to fix than i thought,
just added the fields to my premapped class in the existing DTO only and voila, it worked :) (and the constructor of course)

the difference was astounding, let me advise other beginners to not use "from blah" construct directly if you dont have to :)