+

Search Tips   |   Advanced Search

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 the server port number might be different if we changed the port values:

    DbHostname
    The host name or IP address of the server hosting the database.

    dbType
    The type of database. Use the following valid database types:

    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 the database:

    • Derby: ${WasHome}/derby/lib

    • DB2: ${WasHome}/deploytool/itp/plugins/${dbPlugin}/driver

    • Oracle: {$ORACLE_HOME}/jdbc/lib/

      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 the 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 the 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 the 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 the 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 the data source connects to. Valid values are 2 and 4.

    dataSourceName
    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 we 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.


Parent Create a Portal Application Archive (PAA) file