final String SQL_QUERY = "select new map(l1.labelName as parentName,l2.labelName as childName,l1.jspPage as jspPage) from MenuBean as l1, MenuBean as l2 " +
"where l1.menuId=l2.parentMenuId and l2.typeId =:typeId ORDER BY l1.labelName,l2.labelName";
final Query query = hibernateSession.createQuery(SQL_QUERY);
query.setParameter("typeId", 1);
List<Map> result = PersistenceServiceImpl.cast(query.list());
"where l1.menuId=l2.parentMenuId and l2.typeId =:typeId ORDER BY l1.labelName,l2.labelName";
final Query query = hibernateSession.createQuery(SQL_QUERY);
query.setParameter("typeId", 1);
List<Map> result = PersistenceServiceImpl.cast(query.list());