X-Git-Url: https://gerrit.onap.org/r/gitweb?p=dmaap%2Fdatarouter.git;a=blobdiff_plain;f=datarouter-prov%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fdmaap%2Fdatarouter%2Fprovisioning%2Fbeans%2FIngressRoute.java;h=329e77fa1f89c58e5c3278fe35249f6b4912ad50;hp=4332d7d7167c3af562b82042f941b2ad6ef43af8;hb=534c164c124950a2019acf71d253ac96be12c78c;hpb=e78963869f8f55101d22b0afc06a5c6d6577dbb0

diff --git a/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/IngressRoute.java b/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/IngressRoute.java
index 4332d7d7..329e77fa 100644
--- a/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/IngressRoute.java
+++ b/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/IngressRoute.java
@@ -189,38 +189,6 @@ public class IngressRoute extends NodeClass implements Comparable<IngressRoute>
         return v;
     }
 
-    /**
-     * Get a collection of all Ingress Routes with a particular sequence number.
-     *
-     * @param seq the sequence number to look for
-     * @return the collection (may be empty).
-     */
-    public static Collection<IngressRoute> getIngressRoute(int seq) {
-        Collection<IngressRoute> rv = new ArrayList<IngressRoute>();
-        try {
-            DB db = new DB();
-            @SuppressWarnings("resource")
-            Connection conn = db.getConnection();
-            String sql = "select FEEDID, USERID, SUBNET, NODESET from INGRESS_ROUTES where SEQUENCE = ?";
-            try (PreparedStatement ps = conn.prepareStatement(sql)) {
-                ps.setInt(1, seq);
-                try (ResultSet rs = ps.executeQuery()) {
-                    while (rs.next()) {
-                        int feedid = rs.getInt("FEEDID");
-                        String user = rs.getString("USERID");
-                        String subnet = rs.getString("SUBNET");
-                        int nodeset = rs.getInt("NODESET");
-                        rv.add(new IngressRoute(seq, feedid, user, subnet, nodeset));
-                    }
-                }
-            }
-            db.release(conn);
-        } catch (SQLException e) {
-            intlogger.error("PROV0004 getIngressRoute: " + e.getMessage(), e);
-        }
-        return rv;
-    }
-
     public IngressRoute(int seq, int feedid, String user, String subnet, Collection<String> nodes)
             throws IllegalArgumentException {
         this(seq, feedid, user, subnet);