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

1 files changed, 11 insertions, 11 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.