Skip to content

Change the Default Datasource for BPS

This document guides you to change the underlying databases that are used in business process service(BPS) components.

By default MWARE IAM uses the Embedded H2 database as the BPS datasource. However, you can change this to any database type that is supported by MWARE IAM.

Following are the sample configuration for each database type.

PostgreSQL

  1. Configure the <IS-HOME>/repository/conf/deployment.toml file.

    [bps_database.config]
url = "jdbc:postgresql://localhost:5432/gregdb"
username = "regadmin"
password = "regadmin"
driver = "org.postgresql.Driver"

[bps_database.config.pool_options]
defaultAutoCommit=true
commitOnReturn=true

  2. Execute the database scripts.

    Execute the scripts in the <IS-HOME>/dbscripts/bps/bpel/create/postgresql.sql file against the created database.

MySQL

  1. Configure the <IS-HOME>/repository/conf/deployment.toml file.

    [bps_database.config]
url = "jdbc:mysql://localhost:3306/IAMtest?useSSL=false"
username = "root"
password = "root"
driver = "com.mysql.jdbc.Driver"

  2. Execute the database scripts.

    Execute the scripts in the <IS-HOME>/dbscripts/bps/bpel/create/mysql.sql file against the created database.

DB2

  1. Configure the <IS-HOME>/repository/conf/deployment.toml file.

    [bps_database.config]
url = "jdbc:db2://192.168.108.31:50000/test"
username = "db2inst1"
password = "db2inst1"
driver = "com.ibm.db2.jcc.DB2Driver"

  2. Execute the database scripts.

    Execute the scripts in the <IS-HOME>/dbscripts/bps/bpel/create/db2.sql file against the created database.

MSSQL

  1. Configure the <IS-HOME>/repository/conf/deployment.toml file.

    [bps_database.config]
url = "jdbc:sqlserver://localhost:1433;databaseName=test;SendStringParametersAsUnicode=false"
username = "sa"
password = "pass#word2"
driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"

  2. Execute the database scripts.

    Execute the scripts in the <IS-HOME>/dbscripts/bps/bpel/create/mssql.sql file against the created database.

Oracle

  1. Configure the <IS-HOME>/repository/conf/deployment.toml file.

    [bps_database.config]
url = "jdbc:oracle:thin:@localhost:1521/ORCLPDB"
username = "IS590Test"
password = "ora12c"
driver = "oracle.jdbc.OracleDriver"

  2. Execute the database scripts.

    Execute the scripts in the <IS-HOME>/dbscripts/bps/bpel/create/oracle.sql file against the created database.

Advanced BPS Database Configurations

Apart from the above basic configurations, MWARE IAM supports the following advanced BPS database configurations.

[bps_database.config.pool_options]
maxActive = "50"
maxWait = "60000"
minIdle = "5"
testOnBorrow = true
validationInterval = "30000"
validationQuery = "SELECT 1; COMMIT"

The descriptions for the advanceded configurations can be found in the Performance Tuning documentation.

Top