HCL Workload Automation, Version 9.4

Creating a database connection

About this task

This section explains how to optionally configure the Application Lab database using the db.properties file. Supported databases are:

Derby, both in the embedded and non-embedded (or client/server) configurations
DB2

A Derby database embedded in WebSphere Application Server is created by default when you access Application Lab for the first time. If you want to modify the database, you can edit the db.properties file.

For example, if you want to use the HCL Workload Automation database, edit the parameters in the db.properties file with the appropriate values for DB2.

The configuration file is located in JazzSM install_dir\profile\registry\SimpleUI.

The db.properties file in this example contains the settings for the default configuration, Derby in the embedded environment:

databasePath=./registry/SimpleUI/SIMPLEUI_DB
protocol=jdbc:derby:
databaseUrl=localhost:1527
driver=org.apache.derby.jdbc.EmbeddedDriver
useDataSource=false
datasourceName=jdbc/TDWC
createDatabase=true
useAsEmbeddedConnection=true
user=admin
password=admin
encryptedPassword=false

where

databasePath

Derby database, both in the embedded and client/server configuration: The path where the database is installed.
DB2: The database name.

protocol

The protocol to be used for connecting to the database. Supported values are as follows:

Derby database, both in the embedded and client/server configuration: jdbc:derby:
DB2: jdbc:db2:

databaseUrl

The URL and port for connecting to the database. The default value is localhost:1527. This value applies to the Derby database, both in the embedded and client/server configuration.

driver

The database driver.

Derby database in the embedded configuration: org.apache.derby.jdbc.EmbeddedDriver
Derby database in the client/server configuration: org.apache.derby.jdbc.ClientDriver
DB2: com.ibm.db2.jcc.DB2Driver

useDataSource

Specifies whether to use the local datasource configured for the Dynamic Workload Console. Supported values are true and false. The default value is false.

datasourceName

The name of the datasource to be used. Specify this value if you set useDataSource to true.

createDatabase

This parameter applies to Derby only. If you want to use a DB2 database, you must create it in advance. Specifies whether a database should be created. Supported values are true and false. The default value is true. When set to true, this value causes the creation of a Derby embedded database when you first access the Application Lab.

useAsEmbeddedConnection

Specifies whether to use the Derby Embedded configuration. Supported values are true and false. The default value is true.

If you want to use the Derby client/server configuration, set this value to false and set the driver parameter to org.apache.derby.jdbc.ClientDriver.

If you want to use the DB2 configuration, set this value to false and set the driver parameter to com.ibm.db2.jcc.DB2Driver.

user

The database user.

password

The database user password.

encryptedPassword

Specifies whether the database user password is encrypted.