Hibernate Native SQL

Hiberante HQL/Criteria doesn't support the query for Map collection with dereferenced key object. AddEntity() method will convert the result into domain object, otherwise, it would be an object array.

    String sqlStr = "select t.* from ce_template t, ce_apProfileTemplate_wlanServiceTemplate aw "
         + "where t.id=aw.apProfileTemplateId and t.templateType='APPROFILE' and t.oldId=0 "
         + "and aw.wlanServiceTemplateId=:id";
    Query query = getSession().createSQLQuery(sqlStr)
          .addEntity("t", Template.class)
          .setInteger("id", t.getId());