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%2FStatisticsServlet.java;fp=datarouter-prov%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fdmaap%2Fdatarouter%2Fprovisioning%2FStatisticsServlet.java;h=b77062fa3f426e038a2a91cdaabc58154550b182;hp=3902dc63cf350d7e8fefe3eb0a4c50345ab1433b;hb=5ecbc83f99f72a197447857f8520449d4cba040e;hpb=c2c9a18dc3212fa69bcb173f5b0ed97c7996c044

diff --git a/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/StatisticsServlet.java b/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/StatisticsServlet.java
index 3902dc63..b77062fa 100755
--- a/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/StatisticsServlet.java
+++ b/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/StatisticsServlet.java
@@ -546,10 +546,8 @@ public class StatisticsServlet extends BaseServlet {
       intlogger.debug(filterQuery);
       long start = System.currentTimeMillis();
       DB db = new DB();
-      ResultSet rs = null;
       try (Connection conn = db.getConnection()) {
-        try (PreparedStatement pst = conn.prepareStatement(filterQuery)) {
-          rs = pst.executeQuery();
+        try (ResultSet rs = conn.prepareStatement(filterQuery).executeQuery()) {
           if (outputType.equals("csv")) {
             resp.setContentType("application/octet-stream");
             Date date = new Date();