Merge "Fixed Critical Sonar Issues in LogServlet.java"
authorRam Koya <rk541m@att.com>
Wed, 29 Aug 2018 13:54:57 +0000 (13:54 +0000)
committerGerrit Code Review <gerrit@onap.org>
Wed, 29 Aug 2018 13:54:57 +0000 (13:54 +0000)
datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/LogServlet.java

index 8614a6e..101c9e6 100644 (file)
@@ -417,13 +417,13 @@ public class LogServlet extends BaseServlet {
         Connection conn = null;\r
         try {\r
             conn = db.getConnection();\r
-            Statement  stmt = conn.createStatement();\r
-            ResultSet rs = stmt.executeQuery(sql);\r
-            while (rs.next()) {\r
-                rh.handleRow(rs);\r
-            }\r
-            rs.close();\r
-            stmt.close();\r
+           try( Statement  stmt = conn.createStatement()){\r
+             try(ResultSet rs = stmt.executeQuery(sql)){\r
+                 while (rs.next()) {\r
+                     rh.handleRow(rs);\r
+                 }\r
+             }\r
+           }\r
         } catch (SQLException sqlException) {\r
             intlogger.info("Failed to get Records. Exception = " +sqlException.getMessage(),sqlException);\r
         } finally {\r