setResultTransformer

protected final List<Map<String,Object>> findBySQL(final String sql, final Object... values) {
List list = getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createSQLQuery(sql);
for (int i = 0; values != null && i < values.length; i++) {
query.setParameter(i, values[i]);
}
query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
List list = query.list();
return list;
}
});
return list;
}