public static ArrayList<bConsultaCompo> getPesquisaCompoAt(String prod, String data_in) throws SQLException, ClassNotFoundException {
        ArrayList<bConsultaCompo> sts = new ArrayList<bConsultaCompo>();
        Connection conPol = conMgr.getConnection("PD");
        ResultSet rs;
        if (conPol == null) {
            throw new SQLException("Numero Maximo de Conexoes Atingida!");
        }
        try {
            call = conPol.prepareCall("{call sp_consulta_componemteAt(?,?)}");
            call.setString(1, prod);
            call.setString(2, data_in);
            rs = call.executeQuery();

            while (rs.next()) {
                bConsultaCompo reg = new bConsultaCompo();
                reg.setCont(rs.getInt("f1"));
                reg.setCod_prod(rs.getString("f2"));
                reg.setStr_compo(rs.getString("f3"));
                reg.setDescricao1(rs.getString("f4"));

                sts.add(reg);
            }
        } finally {
            if (conPol != null) {
                conMgr.freeConnection("PD", conPol);
            }
        }
        return sts;
    }