Database properties for the Solution Installer

Some Portal Application Archive (PAA) files require access to an external database. The database properties are stored in either the assemblyName.properties file for the assembly or in the componentName.properties file of the component requiring database support.

The Solution Installer uses the following database properties:
dbName
The name of the database created to store tables required by the PAA file. Ideally, this should be specified in the default.properties file, especially if the name of the database is explicitly included in the table population scripts.
DbPort
Specify the database port number. The following examples are default port numbers for each database, but your server port number might be different if you changed the port values:
  • Derby: 1527
  • DB2®: 50000
  • Oracle: 1521
  • SQL Server : 1433
DbHostname
The host name or IP address of the server hosting the database.
dbType
The type of database. Use the following valid database types:
  • Derby: derby
  • DB2®: db2
  • Oracle: oracle
  • SQL Server : SQL Server
dbProviderName
The name of jdbc provider to be used. Use the following example jdbc provider names:
  • Derby: wpdbJDBC_derby
  • DB2®: wpdbJDBC_db2
  • Oracle: wpdbJDBC_oracle
  • SQL Server : wpdbJDBC_sqlserver
dbDriverType
Connection pool data source
dbUsername
The username for connecting to the database.
dbPassword
The password for connecting to the database.
dbDriverName
The name of database driver. Use the following valid driver names:
  • Derby: org.apache.derby.jdbc.EmbeddedDriver
  • DB2®: com.ibm.db2.cc.DB2Driver
  • Oracle: oracle.jdbc.driver.OracleDriver
  • SQL Server : com.microsoft.sqlserver.jdbc.SQLServerDriver
dbDriverPath
The path to the database driver. Use one of the following examples with values specific to your database:
  • Derby: ${WasHome}/derby/lib
  • DB2®: ${WasHome}/deploytool/itp/plugins/${dbPlugin}/driver
  • Oracle: {$ORACLE_HOME}/jdbc/lib/
    Note: ORACLE_HOME is the environment variable specified during the installation of the Oracle database.
  • SQL Server : installation_directory/sqljdbc_2.0/enu
dbClasspath
The database class path value. Use one of the following examples with values specific to your database:
  • Derby: ${dbDriverPath}/derby.jar:${dbDriverPath}/derbyclient.jar:$ {dbDriverPath}/derbytools.jar:${dbDriverPath}/derbynet.jar
  • DB2®: ${dbDriverPath}/db2jcc4.jar:$ {dbDriverPath}/db2jcc_license_cisuz.jar:${dbDriverPath}/db2jcc_license_cu.jar
  • Oracle: ${dbDriverPath}/ojdbc6.jar
  • SQL Server : installation_directory/sqljdbc_2.0/enu/sqljdbc4.jar
dbUrl
The database URL value. Use one of the following examples with values specific to your database:
  • Derby: jdbc:${dbType}:${dbName}
  • DB2®: jdbc:${dbType}://${dbHostname}:${dbPort}/${dbName}
  • Oracle: jdbc:${dbType}:thin:@${dbHostname}:${dbPort}:${dbName}
  • SQL Server : jdbc:sqlserver://hostname:$ {DbPort};SelectMethod=cursor;DatabaseName=tbmesg
dbJndiName
Specify the JNDI name that will be used for a component.
dsTemplateName
The data source template name. Use one of the following examples with values specific to your database:
  • Derby: Derby JDBC Driver DataSource
  • DB2®: DB2 Universal JDBC Driver DataSource
  • Oracle: Oracle JDBC Driver DataSource
  • SQL Server : Microsoft SQL Server JDBC Driver - XA DataSource
jpTemplateName
Use one of the following examples with values specific to your database:
  • Derby: Derby JDBC Provider
  • DB2®: DB2 Universal JDBC Driver Provider
  • Oracle: Oracle JDBC Driver Provider
  • SQL Server : Microsoft SQL Server JDBC Driver
dsDbDriverType
The type of the database driver that the data source connects to. Valid values are 2 and 4. For z/OS®, the recommended value is 4 unless the Monitor database resides on the same z/OS® LPAR as the CEI server, in which case 2 is recommended.
dataSourceName
Specifies the Data Source name will be used for the component.
dbAuthDataAlias
Specifies the Authentication Alias.
db.connectionTimeout
The interval, in seconds, after which a connection request times out and a ConnectionWaitTimeoutException is thrown. Default value is 180.
db.maxConnections
The maximum number of physical connections that you can create in this pool. Default value is 30.
db.reapTime
The interval, in seconds, between runs of the pool maintenance thread. Default value is 120.
db.agedTimeout
The interval in seconds before a physical connection is discarded. Default value is 1800.