spring hibernate.createSQLQuery return as custom entity

Question

I am doing Query query = hibernate.createSQLQuery("select abc,def from table");

Is it possible to auto "parse" the result to "POJO" list?

So that I can do this:

List<CustomPOJO> abc = query.list();    //CustomPOJO is pojo not entity , no @Entity tag

Tadeusz Kopec for Ukraine · Accepted Answer · 2010-02-02 11:02:48Z

11

Try

hibernate.createSQLQuery("select abc,def from table").setResultTransformer(Transformers.aliasToBean(CustomPOJO.class));

like the reference manual suggests.

answered Feb 2, 2010 at 11:02

12.5k6 gold badges60 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1