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.