From: Guangrong Fu <fu.guangrong@zte.com.cn>
Date: Tue, 5 Sep 2017 08:47:58 +0000 (+0800)
Subject: Change the DB from MySQL to PostgreSQL
X-Git-Tag: v1.0.0~49
X-Git-Url: https://gerrit.onap.org/r/gitweb?p=holmes%2Fengine-management.git;a=commitdiff_plain;h=849fb02931f918c067bb34a1d45f81fc436341e7

Change the DB from MySQL to PostgreSQL

Change-Id: I654c872040b4c77f1abee1576bd3952a7ec56f79
Issue-ID: HOLMES-49
Signed-off-by: Guangrong Fu <fu.guangrong@zte.com.cn>
---

diff --git a/engine-d-standalone/src/main/assembly/bin/run.sh b/engine-d-standalone/src/main/assembly/bin/run.sh
index b33862d..59869ee 100644
--- a/engine-d-standalone/src/main/assembly/bin/run.sh
+++ b/engine-d-standalone/src/main/assembly/bin/run.sh
@@ -35,13 +35,13 @@ sed -i "s/activemq.username=.*/activemq.username=activemq/" /home/activemq/apach
 sed -i "s/activemq.password=.*/activemq.password=v1/" /home/activemq/apache-activemq-5.9.0/conf/credentials.properties
 /home/activemq/apache-activemq-5.9.0/bin/activemq start
 
-sed -i "s|url:.*|url: jdbc:mysql://$URL_JDBC/holmes|" "$main_path/conf/engine-d.yml"
+sed -i "s|url:.*|url: jdbc:postgresql://$URL_JDBC/holmes|" "$main_path/conf/engine-d.yml"
 
 
 export SERVICE_IP=`hostname -i`
 echo SERVICE_IP=${SERVICE_IP}
 
-#ActiveMQ IP Configurtion
+#ActiveMQ IP Configurations
 sed -i "s|brokerIp:.*|brokerIp: $SERVICE_IP|" "$main_path/conf/engine-d.yml"
 
 cat "$main_path/conf/engine-d.yml"
diff --git a/engine-d-standalone/src/main/assembly/conf/engine-d.yml b/engine-d-standalone/src/main/assembly/conf/engine-d.yml
index de129c4..06f1913 100644
--- a/engine-d-standalone/src/main/assembly/conf/engine-d.yml
+++ b/engine-d-standalone/src/main/assembly/conf/engine-d.yml
@@ -49,10 +49,10 @@ logging:
 
 
 database:
-  driverClass: com.mysql.jdbc.Driver
+  driverClass: org.postgresql.Driver
   user: holmes
-  password: holmes
-  url: jdbc:mysql://10.74.156.206:3306/holmes
+  password: holmespwd
+  url: jdbc:postgresql://169.254.59.196:5432/holmes
   properties:
     charSet: UTF-8
   maxWaitForConnection: 1s
diff --git a/engine-d/pom.xml b/engine-d/pom.xml
index 0a7c3eb..bc8cb20 100644
--- a/engine-d/pom.xml
+++ b/engine-d/pom.xml
@@ -104,8 +104,8 @@
             <artifactId>lombok</artifactId>
         </dependency>
         <dependency>
-            <groupId>mysql</groupId>
-            <artifactId>mysql-connector-java</artifactId>
+            <groupId>org.postgresql</groupId>
+            <artifactId>postgresql</artifactId>
         </dependency>
         <dependency>
             <groupId>org.quartz-scheduler</groupId>
diff --git a/pom.xml b/pom.xml
index 74af517..522f479 100644
--- a/pom.xml
+++ b/pom.xml
@@ -47,7 +47,7 @@
 
 
         <stringtemplate.version>3.2.1</stringtemplate.version>
-        <mysql.connector.version>5.1.38</mysql.connector.version>
+        <postgres.jdbc.driver.version>42.1.1</postgres.jdbc.driver.version>
         <dropwizard.version>0.8.0</dropwizard.version>
         <swagger.version>1.5.3</swagger.version>
         <lombok.version>1.16.4</lombok.version>
@@ -67,6 +67,11 @@
 
     <dependencyManagement>
         <dependencies>
+            <dependency>
+                <groupId>org.postgresql</groupId>
+                <artifactId>postgresql</artifactId>
+                <version>${postgres.jdbc.driver.version}</version>
+            </dependency>
             <dependency>
                 <groupId>org.onap.msb.java-sdk</groupId>
                 <artifactId>msb-java-sdk</artifactId>
@@ -117,12 +122,6 @@
                 <version>${slf4j.version}</version>
             </dependency>
 
-            <dependency>
-                <groupId>mysql</groupId>
-                <artifactId>mysql-connector-java</artifactId>
-                <version>${mysql.connector.version}</version>
-            </dependency>
-
             <dependency>
                 <groupId>org.antlr</groupId>
                 <artifactId>stringtemplate</artifactId>