0005509: Connection leak in SL_AlertRule_SQL.java

Index: SL_AlertRule_SQL.java
===================================================================
--- SL_AlertRule_SQL.java	(revision 5551)
+++ SL_AlertRule_SQL.java	(revision 8596)
@@ -65,10 +65,11 @@
 
     String msg="";
     
- 
+    PreparedStatement st = null;
+    ResultSet result = null;
     try {
-      PreparedStatement st = this.getPreparedStatement(strSQL);
-      ResultSet result;
+      st = this.getPreparedStatement(strSQL);
+      
       result = st.executeQuery();
       ResultSetMetaData rmeta=result.getMetaData();
       if (!existsColumn(rmeta,"AD_CLIENT_ID"))    msg = "AD_CLIENT_ID ";
@@ -86,6 +87,19 @@
       if (!msg.equals("")) msg = Utility.messageBD(this,"notColumnInQuery",vars.getLanguage()) + msg;
     } catch (Exception ex) {
       msg = "error in query: " + FormatUtilities.replaceJS(ex.toString());
+    } finally {
+      try {
+        if (result != null) {
+          result.close();
+        }
+      } catch (SQLException e) {
+        e.printStackTrace();
+      }
+      try {
+        this.releasePreparedStatement(st);
+      } catch (SQLException e) {
+        e.printStackTrace();
+      }
     }
     
     StringBuffer resultado = new StringBuffer();