[Policy-24,Policy-27] Resolved PushPolicy Issue

Autowired the Hibernate Session Factory.
Removed the Wait timeout and interactive timeout variables from sql
script.
Updated the fwTagpicker sql error.

Change-Id: I567e845f7ba3153241178687310cb734095e8771
Signed-off-by: rb7147 <rb7147@att.com>

1 files changed, 0 insertions, 68 deletions

diff --git a/ECOMP-PAP-REST/src/main/java/org/openecomp/policy/pap/xacml/rest/HibernateSession.java b/ECOMP-PAP-REST/src/main/java/org/openecomp/policy/pap/xacml/rest/HibernateSession.java
deleted file mode 100644
index e2fa702cb..000000000
--- a/ECOMP-PAP-REST/src/main/java/org/openecomp/policy/pap/xacml/rest/HibernateSession.java
+++ /dev/null
@@ -1,68 +0,0 @@
-/*-
- * ============LICENSE_START=======================================================
- * ECOMP-PAP-REST
- * ================================================================================
- * 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.policy.pap.xacml.rest;
-
-import org.hibernate.Session;
-import org.hibernate.SessionFactory;
-import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
-import org.hibernate.cfg.Configuration;
-import org.openecomp.policy.common.logging.flexlogger.FlexLogger;
-import org.openecomp.policy.common.logging.flexlogger.Logger;
-
-public class HibernateSession{
-	
-	private static final Logger LOGGER	= FlexLogger.getLogger(HibernateSession.class);
-	private static SessionFactory xacmlsessionFactory;
-	
-	private HibernateSession(){
-		//Default Constructor
-	}
-	
-	static {
-		try {
-			Configuration configuration= new Configuration();
-			configuration.setProperty("hibernate.connection.url", XACMLPapServlet.getPapDbUrl());
-			configuration.setProperty("hibernate.connection.username", XACMLPapServlet.getPapDbUser());
-			configuration.setProperty("hibernate.connection.password", XACMLPapServlet.getPapDbPassword());
-			configuration.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");
-			configuration.setProperty("hibernate.connection.driver_class", XACMLPapServlet.getPapDbDriver());	
-			configuration.setProperty("hibernate.show_sql", "false");	
-			configuration.setProperty("hibernate.connection.autocommit", "true");
-			configuration.setProperty("hibernate.c3p0.min_size", "5");
-			configuration.setProperty("hibernate.c3p0.max_size", "200");
-			configuration.setProperty("hibernate.c3p0.timeout", "2147483");
-			configuration.setProperty("hibernate.c3p0.idle_test_period", "3600");
-			configuration.setProperty("hibernate.cache.use.query_cache", "false");
-			configuration.setProperty("hibernate.cache.use_second_level_cache", "false");
-			
-			StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder().applySettings(configuration.getProperties());
-			xacmlsessionFactory = configuration.configure("/hibernate.cfg.xml").buildSessionFactory(builder.build());
-			
-		} catch (Exception ex) {
-			LOGGER.error("Exception Occured While Creating Hiberante Session Factory"+ex);
-		}
-	}
-	
-	public static Session getSessionFactory(){
-		return xacmlsessionFactory.openSession();
-	}
-
-}