DbType

--

The type of database applicable to all database connections. The supported values are:

• oracle
• mssqlserver
• mysql

Driver

--

The fully-qualified name of the database driver class that is supplied by the JDBC driver vendor.

Note: Consult your JDBC vendor documentation for the right driver name. For example:
– Oracle: oracle.jdbc.driver.OracleDriver
– Microsoft SQL Server: com.microsoft.sqlserver.jdbc.SQLServerDriver

– MySQL: com.mysql.jdbc.Driver

MinConnections

4

The minimum number of connections to initially create between the server and the database.

MaxConnections

64

The maximum number of connections that will be created between the server and the database.

Note: There is a limit to how many connections a database allows and that limit may limit the server from creating the MaxConnections number of connections. See your database driver documentation for more information about the limit on the number of inbound connections.

IncConnections

2

The number of connections that will be created when a new connection is needed between the RiskMinder components and the database.

MaxIdleConnections

64

The maximum number of idle database connections that the server can maintain.

MaxWaitTimeFor
Connection

30000

The maximum time (in milliseconds) the server must wait for a connection to become available (when there are no available connections) before timing out.

AutoRevert

1

Whether or not the system will attempt to connect to the primary database after a failover occurs.

Set AutoRevert=1, if you have a backup database configured and if you want the server to try to connect back to the primary database after a failover occurs.

MaxTries

3

The number of times the server will attempt to connect to the database before aborting the connection.

ConnRetrySleep
Time

100

The number of milliseconds to delay between attempts to connect to the database.

MonitorSleepTime

50

The amount of time in seconds the Monitoring Thread sleeps between heartbeats checks on all databases.

Profiling

0

Whether the database messages are being logged.

Set the value to 1 if you want to enable logging of database messages.

EnableBrandLicensing

1

Whether a branded ODBC driver is in use.

BrandLicenseFile

IVWF.LIC

The license file name when you use a branded ODBC driver. This parameter is required if the value of EnableBrandLicensing is 1. Otherwise it is ignored.

Important! If present, this value must not be edited.

MaxTransactionRetries

3

The maximum number of times the transaction is retried with a database instance for pre-defined error conditions.

TransactionRetrySleep
Time

10

The interval in milliseconds between two consecutive transaction retries.

Datasource.N

No default

The name of the ODBC System Data Source Name (DSN) pointing to the primary database hosting the server data.

AppServerConnection
PoolName.N

No default

The JNDI name used to look up the connection pool object, if the database connection pooling feature of the application server is being used.

A pool by this JNDI name should be created in the containing application server, and sufficient access right must be given to Web applications for it to use the connection pool.

If the JNDI name is configured in Apache Tomcat, then use a fully qualified JNDI name. For example:

• AppServerConnectionPoolName.1=java:comp/env/SampleDS

For other application servers, specify only the JNDI name. For example:

• AppServerConnectionPoolName.1=SampleDS

See appendix, "Configuring Application Server for Database Connection Pooling" for more information.

If the application server connection pool is not required, then leave this configuration empty.

URL.N

No default

The name of the JDBC data source. For

• Oracle -> jdbc:oracle:thin:<server>:<database_port>:<sid>
• Microsoft SQLServer -> jdbc:sqlserver://<server>:<database_port>;databaseName=<databasename>;selectMethod=cursor
• MySQLServer -> jdbc:mysql://<server>:<database_port>/<database>

Username.N

No default

The user ID used by the server to access the database.

TrustStorePath.N

Note: To be used only if you have SSL configured between RiskMinder and the database.

No default

The SSL Certificate Truststore Path corresponding to Datasource.N. The path (including the filename) refers to the certificate Truststore file, which contains the list of certificates that the client trusts.

Important! The password corresponding to TrustStorePath.N must be securely stored in securestore.enc, with the value of TrustStorePath.N as the key. The dbutil utility is used to achieve this.

Note: See the CA RiskMinder Administration Guide for more information about dbutil.

KeyStorePath.N

Note: This attribute is used only for MySQL.

If you want to configure one-way SSL between RiskMinder and a MySQL Database, this is one of the parameters for which you must specify a value. This parameter holds the SSL Certificate Keystore Path corresponding to Datasource.N. The path (including the filename) refers to the certificate keystore file. The password corresponding to KeyStorePath.N must be securely stored in securestore.enc with the value of KeyStorePath.N as the key.

HostNameInCertificate.N

Note: To be used only if you have SSL configured between RiskMinder and the database.

No default

The value of Common Name (CN) in the subject Distinguished Name (DN) of Datasource.N SSL Certificate in Truststore.