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.