Fórum VRAPTOR+HIBERNATE+POSTGRES #469800

String sql = "select aacc_id as acc, area_id as area, "
                + "area_name as namearea, grp_id group, grp_name as groupname, "
                + "(sgrp_id as sub, sgrp_name as subname "
                + "from homologa.accounts inner join homologa.area_accounts on (aacc_id_accounts=acc_id) "
                + "inner join homologa.area on (area_id=aacc_id_area) "
                + "inner join homologa.groups on (grp_id_area=aacc_id_area) "
                + "inner join homologa.subgroups on (sgrp_id_group=grp_id) "
                + "where acc_id="+codigo+" and acc_active = true and area_active = true "
                + "and aacc_active = true and grp_active = true and sgrp_active = true";
        return session.createSQLQuery(sql).setResultTransformer(
                new AliasToBeanResultTransformer(Menu.class)).list();

@Resource
public class Menu implements Serializable {
    
    @Id @GeneratedValue 
    private long acc;
    private long area;
    private long sub;
    private long group;
    private String namearea;
    private String groupname;
    private String subname;

//GET E SET gerado pela ide