Restore MSOMockServer to the build

Classes in this artifact are needed for unit tests.
For a long term solution, we should find a way to
build these classes into a test-scoped artifact.

Issue: SO-242
Change-Id: I1a57fead07250c841a9f59afb805aea26c7bc102
Signed-off-by: Rob Daugherty <rd472p@att.com>

8 files changed, 0 insertions, 661 deletions

diff --git a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/URNMapPlugin.java b/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/URNMapPlugin.java
deleted file mode 100644
index 4f6ead0299..0000000000
--- a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/URNMapPlugin.java
+++ /dev/null
@@ -1,54 +0,0 @@
-/*-

- * ============LICENSE_START=======================================================

- * ONAP - SO

- * ================================================================================

- * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.

- * ================================================================================

- * Licensed under the Apache License, Version 2.0 (the "License");

- * you may not use this file except in compliance with the License.

- * You may obtain a copy of the License at

- *

- *      http://www.apache.org/licenses/LICENSE-2.0

- *

- * Unless required by applicable law or agreed to in writing, software

- * distributed under the License is distributed on an "AS IS" BASIS,

- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

- * See the License for the specific language governing permissions and

- * limitations under the License.

- * ============LICENSE_END=========================================================

- */

-

-package org.openecomp.camunda.bpmn.plugin.urnmap;

-

-import java.util.Arrays;

-import java.util.HashSet;

-import java.util.List;

-import java.util.Set;

-

-import org.camunda.bpm.cockpit.plugin.spi.impl.AbstractCockpitPlugin;

-import org.openecomp.camunda.bpmn.plugin.urnmap.resources.URNMapPluginRootResource;

-

- 

-

-public class URNMapPlugin  extends AbstractCockpitPlugin{

-	public static final String ID = "urnMap-plugin";

-	  

-	  @Override

-	  public String getId() {

-	    return ID;

-	  }

-

-	  @Override

-	  public Set<Class<?>> getResourceClasses() {

-	    Set<Class<?>> classes = new HashSet<>();

-

-	    classes.add(URNMapPluginRootResource.class);

-

-	    return classes;

-	  }

-

-	  @Override

-	  public List<String> getMappingFiles() {

-		  return Arrays.asList("org/openecomp/camunda/bpm/plugin/urnmap/queries/urnMap.xml");

-	  }

-}

diff --git a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/MyBatisExtendedSessionFactory.java b/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/MyBatisExtendedSessionFactory.java
deleted file mode 100644
index 60d65665fe..0000000000
--- a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/MyBatisExtendedSessionFactory.java
+++ /dev/null
@@ -1,89 +0,0 @@
-/*-

- * ============LICENSE_START=======================================================

- * ONAP - SO

- * ================================================================================

- * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.

- * ================================================================================

- * Licensed under the Apache License, Version 2.0 (the "License");

- * you may not use this file except in compliance with the License.

- * You may obtain a copy of the License at

- * 

- *      http://www.apache.org/licenses/LICENSE-2.0

- * 

- * Unless required by applicable law or agreed to in writing, software

- * distributed under the License is distributed on an "AS IS" BASIS,

- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

- * See the License for the specific language governing permissions and

- * limitations under the License.

- * ============LICENSE_END=========================================================

- */

-

-package org.openecomp.camunda.bpmn.plugin.urnmap.db;

-

-import org.camunda.bpm.engine.ProcessEngineConfiguration;

-import org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl;

-import org.camunda.bpm.engine.impl.cfg.StandaloneProcessEngineConfiguration;

-import org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor;

-import org.camunda.bpm.engine.impl.interceptor.CommandInterceptor;

-import org.camunda.bpm.engine.impl.interceptor.LogInterceptor;

-import org.camunda.bpm.engine.impl.util.ReflectUtil;

-

-import java.io.InputStream;

-import java.util.ArrayList;

-import java.util.Collection;

-import java.util.List;

-

-public class MyBatisExtendedSessionFactory extends StandaloneProcessEngineConfiguration {

-

-  private String resourceName;

-

-  @Override

-  protected void init() {

-    throw new IllegalArgumentException(

-            "Normal 'init' on process engine only used for extended MyBatis mappings is not allowed, please use 'initFromProcessEngineConfiguration'. You cannot construct a process engine with this configuration.");

-  }

-

-  /**

-   * initialize the {@link ProcessEngineConfiguration} from an existing one,

-   * just using the database settings and initialize the database / MyBatis

-   * stuff.

-   */

-  public void initFromProcessEngineConfiguration(ProcessEngineConfigurationImpl processEngineConfiguration, String resourceName) {

-    this.resourceName = resourceName;

-

-    setDatabaseType(processEngineConfiguration.getDatabaseType());

-    setDataSource(processEngineConfiguration.getDataSource());

-    setDatabaseTablePrefix(processEngineConfiguration.getDatabaseTablePrefix());

-

-    initDataSource();

-    initCommandContextFactory();

-    initTransactionFactory();

-    initTransactionContextFactory();

-    initCommandExecutors();

-    initSqlSessionFactory();

-    initIncidentHandlers();

-    initIdentityProviderSessionFactory();

-    initSessionFactories();

-  }

-

-  /**

-   * In order to always open a new command context set the property

-   * "alwaysOpenNew" to true inside the CommandContextInterceptor.

-   *

-   * If you execute the custom queries inside the process engine

-   * (for example in a service task), you have to do this.

-   */

-  @Override

-  protected Collection<? extends CommandInterceptor> getDefaultCommandInterceptorsTxRequired() {

-    List<CommandInterceptor> defaultCommandInterceptorsTxRequired = new ArrayList<>();

-    defaultCommandInterceptorsTxRequired.add(new LogInterceptor());

-    defaultCommandInterceptorsTxRequired.add(new CommandContextInterceptor(commandContextFactory, this, true));

-    return defaultCommandInterceptorsTxRequired;

-  }

-

-  @Override

-  protected InputStream getMyBatisXmlConfigurationSteam() {

-    return ReflectUtil.getResourceAsStream(resourceName);

-  }

-

-}

diff --git a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/MyBatisQueryCommandExecutor.java b/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/MyBatisQueryCommandExecutor.java
deleted file mode 100644
index f81d8c604d..0000000000
--- a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/MyBatisQueryCommandExecutor.java
+++ /dev/null
@@ -1,44 +0,0 @@
-/*-

- * ============LICENSE_START=======================================================

- * ONAP - SO

- * ================================================================================

- * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.

- * ================================================================================

- * Licensed under the Apache License, Version 2.0 (the "License");

- * you may not use this file except in compliance with the License.

- * You may obtain a copy of the License at

- * 

- *      http://www.apache.org/licenses/LICENSE-2.0

- * 

- * Unless required by applicable law or agreed to in writing, software

- * distributed under the License is distributed on an "AS IS" BASIS,

- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

- * See the License for the specific language governing permissions and

- * limitations under the License.

- * ============LICENSE_END=========================================================

- */

-

-package org.openecomp.camunda.bpmn.plugin.urnmap.db;

-

-import org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl;

-import org.camunda.bpm.engine.impl.interceptor.Command;

-

-/**

- * Helper to initialize a minimized process engine which does all the transaction and MyBatis mapping stuff for us

- * and can be used to execute queries.

- */

-public class MyBatisQueryCommandExecutor {

-  

-  private MyBatisExtendedSessionFactory myBatisExtendedSessionFactory;

-

-  public MyBatisQueryCommandExecutor(ProcessEngineConfigurationImpl processEngineConfiguration, String mappingResourceName) {

-    myBatisExtendedSessionFactory = new MyBatisExtendedSessionFactory();

-    myBatisExtendedSessionFactory.initFromProcessEngineConfiguration(processEngineConfiguration, mappingResourceName);

-  }

-  

-  public <T> T executeQueryCommand(Command<T> command) {

-	return myBatisExtendedSessionFactory.getCommandExecutorTxRequired().execute(command);

-  }

-  

-  

-}

diff --git a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/URNData.java b/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/URNData.java
deleted file mode 100644
index b2dcefb304..0000000000
--- a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/URNData.java
+++ /dev/null
@@ -1,47 +0,0 @@
-/*-

- * ============LICENSE_START=======================================================

- * ONAP - SO

- * ================================================================================

- * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.

- * ================================================================================

- * Licensed under the Apache License, Version 2.0 (the "License");

- * you may not use this file except in compliance with the License.

- * You may obtain a copy of the License at

- * 

- *      http://www.apache.org/licenses/LICENSE-2.0

- * 

- * Unless required by applicable law or agreed to in writing, software

- * distributed under the License is distributed on an "AS IS" BASIS,

- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

- * See the License for the specific language governing permissions and

- * limitations under the License.

- * ============LICENSE_END=========================================================

- */

-

-package org.openecomp.camunda.bpmn.plugin.urnmap.db;

-

-public class URNData {

-

-	  private String URNName;

-	  private String URNValue;

-	  private String Ver_;

-	public String getURNName() {

-		return URNName;

-	}

-	public void setURNName(String uRNName) {

-		URNName = uRNName;

-	}

-	public String getURNValue() {

-		return URNValue;

-	}

-	public void setURNValue(String uRNValue) {

-		URNValue = uRNValue;

-	}

-	public String getVer_() {

-		return Ver_;

-	}

-	public void setVer_(String ver_) {

-		Ver_ = ver_;

-	}

-	  

-}

diff --git a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/URNService.java b/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/URNService.java
deleted file mode 100644
index 1eb0ba6f97..0000000000
--- a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/db/URNService.java
+++ /dev/null
@@ -1,49 +0,0 @@
-/*-

- * ============LICENSE_START=======================================================

- * ONAP - SO

- * ================================================================================

- * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.

- * ================================================================================

- * Licensed under the Apache License, Version 2.0 (the "License");

- * you may not use this file except in compliance with the License.

- * You may obtain a copy of the License at

- * 

- *      http://www.apache.org/licenses/LICENSE-2.0

- * 

- * Unless required by applicable law or agreed to in writing, software

- * distributed under the License is distributed on an "AS IS" BASIS,

- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

- * See the License for the specific language governing permissions and

- * limitations under the License.

- * ============LICENSE_END=========================================================

- */

-

-package org.openecomp.camunda.bpmn.plugin.urnmap.db;

-

-import java.util.List;

-

-import org.camunda.bpm.engine.ProcessEngines;

-import org.camunda.bpm.engine.impl.ProcessEngineImpl;

-import org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl;

-import org.camunda.bpm.engine.impl.interceptor.Command;

-import org.camunda.bpm.engine.impl.interceptor.CommandContext;

-

-public class URNService {

-

-

-  public List<URNData> getProperties() {

-    ProcessEngineImpl processEngine = (ProcessEngineImpl) ProcessEngines.getDefaultProcessEngine();

-    ProcessEngineConfigurationImpl processEngineConfiguration = processEngine.getProcessEngineConfiguration();

-

-    MyBatisQueryCommandExecutor commandExecutor = new MyBatisQueryCommandExecutor(processEngineConfiguration, "mappings.xml");

-    return commandExecutor.executeQueryCommand(new Command<List<URNData>>() {

-

-      @SuppressWarnings("unchecked")

-      @Override

-      public List<URNData> execute(CommandContext commandContext) {

-        return (List<URNData>) commandContext.getDbSqlSession().selectList("retrieveUrnKeyValuePair", null);

-      }

-    });

-  }

-

-}

diff --git a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/ProcessInstanceResource.java b/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/ProcessInstanceResource.java
deleted file mode 100644
index 484981c99d..0000000000
--- a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/ProcessInstanceResource.java
+++ /dev/null
@@ -1,98 +0,0 @@
-/*-

- * ============LICENSE_START=======================================================

- * ONAP - SO

- * ================================================================================

- * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.

- * ================================================================================

- * Licensed under the Apache License, Version 2.0 (the "License");

- * you may not use this file except in compliance with the License.

- * You may obtain a copy of the License at

- * 

- *      http://www.apache.org/licenses/LICENSE-2.0

- * 

- * Unless required by applicable law or agreed to in writing, software

- * distributed under the License is distributed on an "AS IS" BASIS,

- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

- * See the License for the specific language governing permissions and

- * limitations under the License.

- * ============LICENSE_END=========================================================

- */

-

-package org.openecomp.camunda.bpmn.plugin.urnmap.resources;

-

-import java.util.List;

-import java.util.StringTokenizer;

-

-import javax.ws.rs.GET;

-import javax.ws.rs.POST;

-import javax.ws.rs.PUT;

-

-import org.slf4j.Logger;

-import org.slf4j.LoggerFactory;

-

-import org.camunda.bpm.cockpit.db.QueryParameters;

-import org.camunda.bpm.cockpit.plugin.resource.AbstractPluginResource;

-import org.openecomp.camunda.bpmn.plugin.urnmap.db.*;

-

-public class ProcessInstanceResource extends AbstractPluginResource {

-

-  private static final Logger log = LoggerFactory.getLogger(ProcessInstanceResource.class);

-

-  public ProcessInstanceResource(String engineName) {

-    super(engineName);

-  }

-

-  @GET

-  public List<URNData> getUrnDataMap() {    

-    List<URNData> list = getQueryService()

-            .executeQuery(

-                    "cockpit.urnMap.retrieveUrnKeyValuePair",

-                    new QueryParameters<URNData>());

-    

-    log.info("urnmap-plugin project - Results Retrieved: ");

-    log.info("URNName: " + "		" + "URNValue: " );

-    for(URNData d: list)

-    {

-    	log.info(  d.getURNName() + "		"  + d.getURNValue());

-    }

-   

-    return list;

-  }

-  

-  @PUT

-  //public void insertNewRow(String key, String value) 

-  public void insertNewRow(String temp) 

-   {  

- 	 log.info("AddNewRow: XXXXXXXXXXXXXXXXX ---> " + temp);

- 	 StringTokenizer st = new StringTokenizer(temp, "|");

- 	 String key = "";

- 	 String value = "";

- 	 

- 	 while(st.hasMoreTokens()) { 

- 		  key = st.nextToken(); 

- 		  value = st.nextToken(); 

- 		  log.info(key + "\t" + value); 

- 		 } 

-  			 

- 	  log.info("AddNewRow: XXXXXXXXXXXXXXXXX ---> key: " + key + " , Value: " + value);

- 	  URNData nRow = new URNData();

- 	  nRow.setVer_("1"); 	 

- 	  nRow.setURNName(key);

- 	  nRow.setURNValue(value);

- 	  

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

- 	 

- 	 log.info("AddNewRow: XXXXXX    END   XXXXXXXXXXX");

-   }

-  

-  @POST

-  public void getPersistData(URNData d) {  

-	  

-	  log.info("getPersistData:  UrnName: " + d.getURNName() + " , URNValue: " + d.getURNValue() );

-	    

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

-     

-	    	    

-	    log.info("XXXXXXXXXX - END - XXXXXXXXXXXXXXX");

-  	}

-}

diff --git a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/URNMapPluginRootResource.java b/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/URNMapPluginRootResource.java
deleted file mode 100644
index e8e5e47c07..0000000000
--- a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/URNMapPluginRootResource.java
+++ /dev/null
@@ -1,41 +0,0 @@
-/*-

- * ============LICENSE_START=======================================================

- * ONAP - SO

- * ================================================================================

- * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.

- * ================================================================================

- * Licensed under the Apache License, Version 2.0 (the "License");

- * you may not use this file except in compliance with the License.

- * You may obtain a copy of the License at

- * 

- *      http://www.apache.org/licenses/LICENSE-2.0

- * 

- * Unless required by applicable law or agreed to in writing, software

- * distributed under the License is distributed on an "AS IS" BASIS,

- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

- * See the License for the specific language governing permissions and

- * limitations under the License.

- * ============LICENSE_END=========================================================

- */

-

-package org.openecomp.camunda.bpmn.plugin.urnmap.resources;

-

-import javax.ws.rs.Path;

-import javax.ws.rs.PathParam;

-

-import org.camunda.bpm.cockpit.plugin.resource.AbstractPluginRootResource;

-import org.openecomp.camunda.bpmn.plugin.urnmap.URNMapPlugin;

-

-@SuppressWarnings("deprecation")

-@Path("plugin/" + URNMapPlugin.ID)

-public class URNMapPluginRootResource extends AbstractPluginRootResource

-{

-	  public URNMapPluginRootResource() {

-		  	  super(URNMapPlugin.ID);

-	  }

-

-	  @Path("{engineName}/process-instance") 

-	  public URNResource getProcessInstanceResource(@PathParam("engineName") String engineName) {

-	    return subResource(new URNResource(engineName), engineName);

-	  }

-}

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
deleted file mode 100644
index 938b9d377f..0000000000
--- a/bpmn/MSOURN-plugin/src/main/java/org/openecomp/camunda/bpmn/plugin/urnmap/resources/URNResource.java
+++ /dev/null
@@ -1,239 +0,0 @@
-/*-

- * ============LICENSE_START=======================================================

- * ONAP - SO

- * ================================================================================

- * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.

- * ================================================================================

- * Licensed under the Apache License, Version 2.0 (the "License");

- * you may not use this file except in compliance with the License.

- * You may obtain a copy of the License at

- * 

- *      http://www.apache.org/licenses/LICENSE-2.0

- * 

- * Unless required by applicable law or agreed to in writing, software

- * distributed under the License is distributed on an "AS IS" BASIS,

- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

- * See the License for the specific language governing permissions and

- * limitations under the License.

- * ============LICENSE_END=========================================================

- */

-

-package org.openecomp.camunda.bpmn.plugin.urnmap.resources;

-/***

-import java.beans.Statement;

-import java.sql.DriverManager;

-import java.sql.ResultSet;

-import java.sql.SQLException;

-*/

-import java.sql.Connection;

-import java.sql.PreparedStatement;

-import java.sql.ResultSet;

-import java.sql.SQLException;

-import java.util.ArrayList;

-import java.util.List;

-import java.util.StringTokenizer;

-

-import javax.naming.Context;

-import javax.naming.InitialContext;

-import javax.sql.DataSource;

-import javax.ws.rs.GET;

-import javax.ws.rs.POST;

-import javax.ws.rs.PUT;

-

-import org.camunda.bpm.cockpit.db.QueryParameters;

-import org.camunda.bpm.cockpit.plugin.resource.AbstractCockpitPluginResource;

-

-

-//import org.camunda.bpm.cockpit.plugin.resource.AbstractPluginResource;

-import org.openecomp.camunda.bpmn.plugin.urnmap.db.URNData;

-import org.openecomp.mso.logger.MsoLogger;

-

-

-//public class ProcessInstanceResource extends AbstractPluginResource {

-public class URNResource extends AbstractCockpitPluginResource{

-  public URNResource(String engineName) {

-    super(engineName);

-  }

-  

-  private Connection conn;

-  private static MsoLogger msoLogger = MsoLogger.getMsoLogger(MsoLogger.Catalog.BPEL);

-  @GET

-  public List<URNData> getUrnDataMap() 

-  {  

-	  List<URNData> list = new ArrayList();

-	  PreparedStatement psData = null;

-	  try {

-			

-		    conn = getDBConnection();

-			psData = conn

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

-			    

-			    ResultSet r = psData.executeQuery();

-			    

-				while(r.next()) 

-				{

-					URNData d = new URNData();

-					d.setURNName(r.getString("NAME_"));

-					d.setURNValue(r.getString("VALUE_"));

-					d.setVer_( r.getString("REV_"));

-					

-					list.add(d);					

-				}

-				

-		} catch (Exception e) 

-		{

-			msoLogger.debug("Exception in getUrnDataMap ", e);			

-		} finally {

-			if(psData != null){

-				try {

-					psData.close();

-					conn.close();

-				} catch (SQLException e) {

-					msoLogger.debug("Exception while closing the PreparedStatement: ", e);

-				}

-			}

-			if(conn != null){

-				try {

-					conn.close();

-				} catch (SQLException e) {

-					msoLogger.debug("Exception while closing the connection: ", e);

-				}

-			}

-		}

-     

-    for(URNData d: list)

-    {

-    	msoLogger.debug(  d.getURNName() + "		"  + d.getURNValue());

-    	//msoLogger.debug("Started Executing " + getTaskName());

-    	msoLogger.debug("Started Executing " + d.getURNName() + " " + d.getURNValue());

-    }

-   

-    return list;

-  }

-  

-  public List<URNData> getUrnDataMapOLD() 

-  {  

-	  

-    List<URNData> list = getQueryService()

-            .executeQuery("cockpit.urnMap.retrieveUrnKeyValuePair", new QueryParameters<URNData>());

-    

-    msoLogger.debug("urnmap-plugin project - Results Retrieved: ");

-    msoLogger.debug("URNName: " + "		" + "URNValue: " );

-    

-    for(URNData d: list)

-    {

-    	msoLogger.debug( d.getURNName() + "		"  + d.getURNValue());

-    }

-   

-    return list;

-  }

-  

-  public Connection getDBConnection()

-  {

-	  try {

-			

-			if(conn == null)

-			{

-				Context ctx = new InitialContext();

-			    DataSource ds = (DataSource)ctx.lookup("java:jboss/datasources/ProcessEngine");//jboss

-		    	conn =			ds.getConnection();

-	 

-			}			 

-			

-		} catch (Exception e) 

-		{

-			msoLogger.debug("Exception in DBConnection ", e);

-		}

-	  

-	  return conn;

-  }

-  

-  @PUT

-  public void insertNewRow(String temp) 

-   {  

- 	 msoLogger.debug("AddNewRow: XXXXXXXXXXXXXXXXX ---> " + temp);

- 	 msoLogger.debug("AddNewRow: EngineName  ---> " + engineName);

- 	 

- 	 StringTokenizer st = new StringTokenizer(temp, "|");

- 	 String key_ = "";

- 	 String value_ = "";

- 	 

- 	 while(st.hasMoreTokens()) { 

- 		  key_ = st.nextToken(); 

- 		  value_ = st.nextToken(); 

- 		 msoLogger.debug(key_ + "\t" + value_); 

- 		 } 

-  			 

-       msoLogger.debug("AddNewRow: XXXXXXXXXXXXXXXXX ---> key: " + key_ + " , Value: " + value_);

- 	  final URNData nRow = new URNData();

- 	  nRow.setVer_("1");

- 	  PreparedStatement psData = null;

-	  

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

-		try {

-			

-  		    conn = getDBConnection();

-			psData = conn

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

-			    

-			    psData.executeUpdate();		 

-			

-		} catch (Exception e) 

-		{

-			msoLogger.debug("Exception in insertNewRow ", e);

-		}finally {

-			if(psData != null){

-				try {

-					psData.close();

-					conn.close();

-				} catch (SQLException e) {

-					msoLogger.debug("Exception while closing the PreparedStatement: ", e);

-				}

-			}

-			if(conn != null){

-				try {

-					conn.close();

-				} catch (SQLException e) {

-					msoLogger.debug("Exception while closing the connection: ", e);

-				}

-			}

-		}

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

-   }

-  

-  @POST

-  public void getPersistData(URNData d) {  

-	  

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

- 	    PreparedStatement psData = null;

-	  try {

-			

-		    conn = getDBConnection();

-			psData = conn

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

-			    

-			    psData.executeUpdate();

-			   

-		} catch (Exception e) 

-		{

-			msoLogger.debug("Exception in PersistData ", e);

-		}finally {

-			if(psData != null){

-				try {

-					psData.close();

-					conn.close();

-				} catch (SQLException e) {

-					msoLogger.debug("Exception while closing the PreparedStatement: ", e);

-				}

-			}

-			if(conn != null){

-				try {

-					conn.close();

-				} catch (SQLException e) {

-					msoLogger.debug("Exception while closing the connection: ", e);

-				}

-			}

-		}

-	 

-  	}

-}