ReportImpl result = new ReportImpl();
 try {

            session = sessionFactory.openSession();
            java.sql.Connection con = session.connection();

            CallableStatement statement = null;

            statement = con.prepareCall("{CALL PR$ONLINE_REPORT(? ,?, ? , ?)}");


            statement.setLong(1, tId);
            statement.setLong(2, lgn);
            statement.setTimestamp(3, new Timestamp(from.getTime()));
            statement.setTimestamp(4, new Timestamp(till.getTime()));

            statement.execute();


           //

            ResultSet rs1 = statement.getResultSet();
            while (rs1.next()) {
                result.setAgentName(rs1.getString(1));
            }
            rs1.close();



            if (statement.getMoreResults()) {
                ArrayList<Tuple3<String, String, String>> reports = new ArrayList<Tuple3<String, String, String>>();

                ResultSet rs2 = statement.getResultSet();
                while (rs2.next()) {
                    reports.add(new Tuple3<String, String, String>(rs2.getString(1), rs2.getString(2), rs2.getString(3)));
                }
                result.setSales(reports);
                rs2.close();
            }


         if (statement.getMoreResults()) {
                ResultSet rs2 = statement.getResultSet();
                while (rs2.next()) {
                    result.setSalesSum(rs2.getString(1));
                }
                rs2.close();
            }

          if (statement.getMoreResults()) {
                ArrayList<Tuple3<String, String, String>> reports = new ArrayList<Tuple3<String, String, String>>();
                ResultSet rs2 = statement.getResultSet();
                while (rs2.next()) {
                    reports.add(new Tuple3<String, String, String>(rs2.getString(1), rs2.getString(2), rs2.getString(3)));
                }
                result.setPayments(reports);
                rs2.close();
            }

            if (statement.getMoreResults()) {
                ResultSet rs2 = statement.getResultSet();
                while (rs2.next()) {
                    result.setPaymentsSum(rs2.getString(1));
                }

                rs2.close();
            }

            if (statement.getMoreResults()) {
                ResultSet rs2 = statement.getResultSet();
                while (rs2.next()) {
                    result.setTotalSum(rs2.getString(1));
                }

                rs2.close();
            }


            statement.close();

@Entity(name="DepartmentEntity")
@Table (name="department")

@Entity //  нужно убрать , т.к. нет никакого entity  но без него не регистритуется хранимка !!!!!
@NamedStoredProcedureQuery(name = "GET_MPARAMETERS", procedureName = "PR_GET_MPARAMETERS",
        parameters = {
                @StoredProcedureParameter(mode = ParameterMode.IN, name = "a_id", type = Integer.class),
                @StoredProcedureParameter(mode = ParameterMode.IN, name = "a_dr", type = Integer.class) },
        resultSetMappings={"MPropertiesResultSetMapping", "CatResultSetMapping", "SignResultSetMapping"}
)
public class ResultEntity implements Serializable{

    private static final long serialVersionUID = 1L;


    @Embedded// думаю это ненужно 
    private MProperties mProperties;

    @Embedded //// думаю это ненужно 
    private  Cat сat;

    @EmbeddedId // тут нужен  @Embedded
   private  Sign sign;

    public MProperties getMProperties() {
        return mProperties;
    }

    public void setMProperties(MProperties mProperties) {
        this.mProperties = mProperties;
    }

    public Cat getCat() {
        return cat;
    }

    public void setCat(Cat cat) {
        this.cat = cat;
    }

    public Vsign getSign() {
        return sign;
    }

    public void setSign(Sign sign) {
        this.sign = sign;
    }
}

@Embeddable // думаю это ненужно 
@SqlResultSetMappings({
        @SqlResultSetMapping(
                name = "MPropertiesResultSetMapping",
                entities = {
                        @EntityResult(entityClass = MProperties.class)
                }
        )

})
public class MProperties implements Serializable {

    private static final long serialVersionUID = 1L;


    private Long a_id_ans;

    private Integer a_column;

    String a_draw;



    public Integer getA_column() {
        return a_column;
    }

    public Long getA_id_ans() {
        return a_id_ans;
    }

    public String getA_draw() {
        return a_draw;
    }
}