Fix Sonar bugs

[dmaap/datarouter.git] / datarouter-prov / src / main / java / org / onap / dmaap / datarouter / provisioning / StatisticsServlet.java

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 3902dc6..b77062f 100755 (executable)
--- 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);\r
       long start = System.currentTimeMillis();\r
       DB db = new DB();\r
-      ResultSet rs = null;\r
       try (Connection conn = db.getConnection()) {\r
-        try (PreparedStatement pst = conn.prepareStatement(filterQuery)) {\r
-          rs = pst.executeQuery();\r
+        try (ResultSet rs = conn.prepareStatement(filterQuery).executeQuery()) {\r
           if (outputType.equals("csv")) {\r
             resp.setContentType("application/octet-stream");\r
             Date date = new Date();\r