Merge "Resolved License Issues for packages"
diff --git a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/URNResource.java b/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/URNResource.java
index 1304fc2..85f9753 100644
--- a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/URNResource.java
+++ b/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/URNResource.java
@@ -60,14 +60,15 @@
   public List<URNData> getUrnDataMap() 

   {  

 	  List<URNData> list = new ArrayList();

-	  

+	  PreparedStatement psData = null;

+	  ResultSet r = null;

 	  try {

 			

 		    conn = getDBConnection();

-			    PreparedStatement psData = conn

+			    psData = conn

 						.prepareStatement("select * from MSO_URN_MAPPING order by NAME_");

 			    

-			    ResultSet r = psData.executeQuery();

+			    r = psData.executeQuery();

 			    

 				while(r.next()) 

 				{

@@ -78,14 +79,15 @@
 					

 					list.add(d);					

 				}

-				

-			    psData.close();

-				conn.close();

 			

 		} catch (Exception e) 

 		{

 			

 			e.printStackTrace();

+		} finally {

+			try { r.close(); } catch (Exception e) { /* ignored */ }

+			try { psData.close(); } catch (Exception e) { /* ignored */ }

+			try { conn.close(); } catch (Exception e) { /* ignored */ }

 		}

      

     for(URNData d: list)

@@ -158,24 +160,26 @@
  	  nRow.setVer_("1"); 	

  	  final String myKey = key_;

  	  final String myValue = value_;

- 	  

+	   

+	    PreparedStatement psData = null;

 		msoLogger.debug("----------- START ----------------------");

 		try {

 			

   		    conn = getDBConnection();

-			    PreparedStatement psData = conn

+				psData = conn

 						.prepareStatement("Insert into MSO_URN_MAPPING values ('" + key_ + "', '" + value_  + "', '1')");

 			    

 			    psData.executeUpdate();

 			    

-			    psData.close();

-				conn.close();

 			//}			 

 			

 		} catch (Exception e) 

 		{

 			

 			e.printStackTrace();

+		} finally {

+			try { psData.close(); } catch (Exception e) { /* ignored */ }

+			try { conn.close(); } catch (Exception e) { /* ignored */ }

 		}

  	// getQueryService().executeQuery("cockpit.urnMap.insertNewRow", nRow, URNData.class);

    }

@@ -184,21 +188,22 @@
   public void getPersistData(URNData d) {  

 	  

 	    	//getQueryService().executeQuery("cockpit.urnMap.persistURNData", d, URNData.class);

- 	    

+	  PreparedStatement psData = null;

 	  try {

 			

 		    conn = getDBConnection();

-			PreparedStatement psData = conn

+				psData = conn

 						.prepareStatement("UPDATE MSO_URN_MAPPING set VALUE_ ='"+ d.getURNValue() + "' WHERE NAME_='" + d.getURNName() + "'");

 			    

 			    psData.executeUpdate();

 			    

-			    psData.close();

-				conn.close();

 		} catch (Exception e) 

 		{

 			

 			e.printStackTrace();

+		} finally {

+			try { psData.close(); } catch (Exception e) { /* ignored */ }

+			try { conn.close(); } catch (Exception e) { /* ignored */ }

 		}

 	 

   	}

diff --git a/mso-api-handlers/mso-api-handler-infra/src/main/java/org/openecomp/mso/apihandlerinfra/tenantisolation/CloudOrchestration.java b/mso-api-handlers/mso-api-handler-infra/src/main/java/org/openecomp/mso/apihandlerinfra/tenantisolation/CloudOrchestration.java
index 4801811..ecbe97c 100644
--- a/mso-api-handlers/mso-api-handler-infra/src/main/java/org/openecomp/mso/apihandlerinfra/tenantisolation/CloudOrchestration.java
+++ b/mso-api-handlers/mso-api-handler-infra/src/main/java/org/openecomp/mso/apihandlerinfra/tenantisolation/CloudOrchestration.java
@@ -281,10 +281,11 @@
 	
 	private CloudOrchestrationRequest convertJsonToCloudOrchestrationRequest(String requestJSON, Action action, long startTime,
 		CloudOrchestrationRequest cor) throws Exception {
+		CloudOrchestrationRequest new_cor = null;
 		try{
 			msoLogger.debug("Converting incoming JSON request to Object");
 			ObjectMapper mapper = new ObjectMapper();
-			cor = mapper.readValue(requestJSON, CloudOrchestrationRequest.class);
+			new_cor = mapper.readValue(requestJSON, CloudOrchestrationRequest.class);
 		} catch(Exception e){
 			msoLogger.debug ("Mapping of request to JSON object failed : ", e);
 			if (getTenantIsolationRequest().getRequestId () != null) {
@@ -295,7 +296,7 @@
 			msoLogger.recordAuditEvent (startTime, MsoLogger.StatusCode.ERROR, MsoLogger.ResponseCode.SchemaError, "Mapping of request to JSON object failed");
 			throw new Exception(e);
 		}
-		return cor;
+		return new_cor;
 	}
 	
 	public TenantIsolationRequest getTenantIsolationRequest() {