From: Timoney, Daniel (dt5972) <dtimoney@att.com>
Date: Tue, 14 Mar 2017 15:10:54 +0000 (+0000)
Subject: [ADMPORTAL] Connection leak fix
X-Git-Url: https://gerrit.onap.org/r/gitweb?p=sdnc%2Foam.git;a=commitdiff_plain;h=18e4ba71f5b4c553e045c6d02e1a0a5a000a2d6b

[ADMPORTAL] Connection leak fix

Added connection.release()

Change-Id: I1caeb4e9ea69099e37e8dc0c3869e1100699b40b
Signed-off-by: Timoney, Daniel (dt5972) <dtimoney@att.com>
---

diff --git a/admportal/server/router/routes/dbRoutes.js b/admportal/server/router/routes/dbRoutes.js
index d2f40b52..34a90c7b 100644
--- a/admportal/server/router/routes/dbRoutes.js
+++ b/admportal/server/router/routes/dbRoutes.js
@@ -275,11 +275,13 @@ exports.saveUser = function(req,res){
 
 		connection.query(sql, function(err,result){
 			if(err){
+				connection.release();
 				res.render("pages/signup", {result:{code:'error', msg:"Unable to get database connection. " + String(err)},header:process.env.MAIN_MENU});
 				return;
 			}
 			if (result.length == 1 || result.length > 1)
 			{
+				connection.release();
 				res.render("pages/signup", {result:{code:'error', msg:'User Information already exists.'},header:process.env.MAIN_MENU});
 				return;
 			}