public static ArrayList<bConsulta> getListaGMP(String dt1) throws SQLException, ClassNotFoundException {
        ArrayList<bConsulta> sts = new ArrayList<bConsulta>();
        Connection conPol = conMgr.getConnection("PD");
        if (conPol == null) {
            throw new SQLException("Numero Maximo de Conexoes Atingida!");
        }
        try {
            Statement stmt = conPol.createStatement();
            String strQl;
            strQl = " SELECT DISTINCT "
                    + "  tb_registro.cod_gmp, "
                    + "  tb_gmp.str_gmp "
                    + " FROM "
                    + "  tb_registro, "
                    + "  tb_gmp "
                    + " WHERE "
                    + "  tb_gmp.cod_gmp = tb_registro.cod_gmp AND "
                    + "  date_trunc('month',  datah) =  TO_timestamp('" + dt1 + "','MM/YYYY') "
                    + " ORDER BY str_gmp; ";

            ResultSet rs = stmt.executeQuery(strQl);

            while (rs.next()) {
                bConsulta reg = new bConsulta();
                reg.setCod_prod(String.valueOf(rs.getInt("cod_gmp")));
                reg.setStr_prod(rs.getString("str_gmp"));
                sts.add(reg);
            }
        } finally {
            if (conPol != null) {
                conMgr.freeConnection("PD", conPol);
            }
        }
        return sts;
    }