Refactoring to support H2 DB for local run

Updating pom.xml to remove scope test for H2 DB
Updating H2DB version to 1.4.200
Updating application-dev.properties DB properties to H2 DB

Issue-ID: CCSDK-3740
Signed-off-by: Singal, Kapil (ks220y) <ks220y@att.com>
Change-Id: I57f90a0b0788510ab736d2f9dce28a0cbf3da12d

3 files changed, 14 insertions, 16 deletions

diff --git a/ms/blueprintsprocessor/application/src/main/resources/application-dev.properties b/ms/blueprintsprocessor/application/src/main/resources/application-dev.properties
index e20e2649d..cac9a0034 100755
--- a/ms/blueprintsprocessor/application/src/main/resources/application-dev.properties
+++ b/ms/blueprintsprocessor/application/src/main/resources/application-dev.properties
@@ -22,7 +22,7 @@
 #Current paths assume relative paths to $CDS_DIR/ms/blueprintsprocessor/application
 
 # Web server config
-server.port=8081
+server.port=8080
 # Used in Health Check
 security.user.password: {bcrypt}$2a$10$duaUzVUVW0YPQCSIbGEkQOXwafZGwQ/b32/Ys4R1iwSSawFgz7QNu
 security.user.name: ccsdkapps
@@ -51,7 +51,7 @@ blueprintsprocessor.loadCbaExtension=zip
 ### END -Controller Blueprints Properties
 
 blueprintsprocessor.grpcEnable=false
-blueprintsprocessor.httpPort=8081
+blueprintsprocessor.httpPort=8080
 blueprintsprocessor.grpcPort=9111
 
 # Command executor
@@ -75,20 +75,20 @@ blueprintsprocessor.grpcclient.py-executor.trustCertCollection=src/main/resource
 
 
 # db
-blueprintsprocessor.db.url=jdbc:mysql://localhost:3306/sdnctl
-blueprintsprocessor.db.username=sdnctl
-blueprintsprocessor.db.password=sdnctl
-blueprintsprocessor.db.driverClassName=org.mariadb.jdbc.Driver
+blueprintsprocessor.db.url=jdbc:h2:mem:sdnctl;MODE=MySQL;DATABASE_TO_LOWER=TRUE;CASE_INSENSITIVE_IDENTIFIERS=TRUE
+blueprintsprocessor.db.username=sa
+blueprintsprocessor.db.password=password
+blueprintsprocessor.db.driverClassName=org.h2.Driver
 blueprintsprocessor.db.hibernateHbm2ddlAuto=update
 blueprintsprocessor.db.hibernateDDLAuto=update
 blueprintsprocessor.db.hibernateNamingStrategy=org.hibernate.cfg.ImprovedNamingStrategy
-blueprintsprocessor.db.hibernateDialect=org.hibernate.dialect.MySQL5InnoDBDialect
+blueprintsprocessor.db.hibernateDialect=org.hibernate.dialect.H2Dialect
 
 # processor-db endpoint
-blueprintsprocessor.db.processor-db.type=maria-db
-blueprintsprocessor.db.processor-db.url=jdbc:mysql://localhost:3306/sdnctl
-blueprintsprocessor.db.processor-db.username=root
-blueprintsprocessor.db.processor-db.password=secretpassword
+blueprintsprocessor.db.processor-db.type=mysql-db
+blueprintsprocessor.db.processor-db.url=jdbc:h2:mem:sdnctl;MODE=MySQL;DATABASE_TO_LOWER=TRUE;CASE_INSENSITIVE_IDENTIFIERS=TRUE
+blueprintsprocessor.db.processor-db.username=sa
+blueprintsprocessor.db.processor-db.password=password
 
 # Python executor
 ### If testing in docker, use the absolute paths as Docker view of filesystem will not respect relative paths.
diff --git a/ms/blueprintsprocessor/modules/inbounds/pom.xml b/ms/blueprintsprocessor/modules/inbounds/pom.xml
index 3ee279cec..42a425c4a 100644
--- a/ms/blueprintsprocessor/modules/inbounds/pom.xml
+++ b/ms/blueprintsprocessor/modules/inbounds/pom.xml
@@ -92,7 +92,6 @@
         <dependency>
             <groupId>com.h2database</groupId>
             <artifactId>h2</artifactId>
-            <scope>test</scope>
         </dependency>
     </dependencies>
 </project>
diff --git a/ms/blueprintsprocessor/parent/pom.xml b/ms/blueprintsprocessor/parent/pom.xml
index 8f4af1fbd..99ae887de 100755
--- a/ms/blueprintsprocessor/parent/pom.xml
+++ b/ms/blueprintsprocessor/parent/pom.xml
@@ -38,14 +38,14 @@
         <onap.logger.slf4j>1.2.2</onap.logger.slf4j>
         <hazelcast.version>4.2.2</hazelcast.version>
 
-        <h2database.version>1.4.197</h2database.version>
+        <h2database.version>1.4.200</h2database.version>
         <powermock.version>1.7.4</powermock.version>
         <mockkserver.version>5.5.1</mockkserver.version>
         <json.unit.version>2.8.0</json.unit.version>
         <xmlunit.version>2.6.3</xmlunit.version>
 
-  
-   
+
+
         <sshd.version>2.2.0</sshd.version>
         <jsch.version>0.1.55</jsch.version>
         <jslt.version>0.1.8</jslt.version>
@@ -499,7 +499,6 @@
                 <groupId>com.h2database</groupId>
                 <artifactId>h2</artifactId>
                 <version>${h2database.version}</version>
-                <scope>test</scope>
             </dependency>
 
             <!-- Test Dependency -->