Configuring Database and its Settings

This section helps you to install the supported databases.

Callback Registry is a sql based product microservice. So, there is a need to configure database properties in the properties file to use the database. Spring beans can be used to load the entity files and create table at the time of deployment. Once you configure the below mentioned database properties and deploy the war in the application, the tables will be created.

The supported databases are:

• MySql
• Oracle

Installing MySql Database

Procedure:

1. Download and Install the database with the help of support docs available in the Mysql website
2. Configure the user and other properties for the database as required.

   The db.properties file is available in the below wars:

   • ms-callbackregistry-j2ee.war (for api)
   • ms-callbackregistry-data-ingester.war

   These wars contain the db.properties file in which you have to set the database configuration.

The below table explains the properties that have to be defined and significance of the properties.

S.No	Database Property	Value	Description
1	database.name	callbackregistrydb	The database name to which the war needs to connect to
2	driver.name	com.mysql.jdbc.Driver	the driver used to establish connection with db
3	dialect	org.hibernate.dialect.MySQL5InnoDBDialect	the dialect used in db connection
4	db.connection.url	jdbc:mysql://db-service:3306/callbackregistrydb	jdbc connection url with host and port
5	db.username	root	database username
6	db.password	root	database password

Using the above properties, you can connect to the database and perform the business operations for callback registry microservices.

Installing Oracle Database

Procedure:

1. Download and install the database with the help of support documents available in the Oracle website.
2. Configure the user and other properties for the database as required.

   The db.properties file is available in the below wars.

   • ms-callbackregistry-j2ee.war (for api)
   • ms-callbackregistry-data-ingester.war

   These wars have the db.properties file in which you have to set the database configuration.

   In the above available table you have to just change the dialect and driver and connection url base of oracle. below We will attach a sample

   driver.name=oracle.jdbc.driver.OracleDriver
   
   dialect= org.hibernate.dialect.Oracle10gDialect
   
   db.connection.url=jdbc:oracle:thin:@localhost:1521:MSDEV