wkplc_dbtype.properties file reference

The wkplc_dbtype.properties file stores information about database drivers, JDBC libraries, and driver providers. This information in this file is used when configuring databases to use with WebSphere Portal. Information in this file is expressed as a paired set of parameters. For each key, specify a a value that is appropriate for environment. In some cases default values are provided for ease-of-use.

Database safe mode properties

This setting can help prevent unintentional database creation, initialization and removal.
DbSafeMode

Description: This value only applies to database specific tasks.
Value: The following are valid values:
true: safe mode is on and the databases are not created, initialized, or removed.

false: safe mode is off and the databases are created, initialized, or removed.


Examples: No examples are available.

Default: false

Derby properties

The following property value pairs are specific to the Derby database. Derby is not a production environment database, but it is ideal for getting started with the product.
derby.DbDriver

Description: Name of class SqlProcessor will use to import SQL files.
Value: class name
Examples: No examples are available.

Default: org.apache.derby.jdbc.EmbeddedDriver

derby.DbLibrary

Description: Directory and name of the ZIP or JAR file containing the JDBC driver class.
Value: directory path, using the system specific file separator names. For Windows use a semicolon (;) and for UNIX use a colon (:).
Examples: Examples are provided for each OS:
Linux: /opt/IBM/WebSphere/AppServer/derby/lib/derby.jar

Windows: C:/IBM/WebSphere/PortalExpress/AppServer/derby/lib/derby.jar

Default: Default values are unique for each OS.

derby.JdbcProviderName

Description: Name of JDBC provider to be used.
Value: Alphanumeric text string
Examples: No examples are available.

Default: wpdbJDBC_derby

IBM DB2 Database properties

The following property value pairs are specific to IBM DB2 database.
db2.DbDriver

Description: The name of class SqlProcessor will use to import SQL files.
Value: class name
Examples: com.ibm.db2.jcc.DB2Driver

Default: com.ibm.db2.jcc.DB2Driver

db2.DbLibrary

Description: The directory and name of the ZIP or JAR file containing JDBC driver class. Use system specific file separator names,for Windows use a semicolon and for UNIX use a colon.
Value: Valid values include the following, where <SQLLIB> is a variable that must be replaced with the specific information from OS:
DB2 version 9.1: <SQLLIB> /java/db2jcc.jar; <SQLLIB> /java/db2jcc_license_cu.jar

All other DB 2 versions use the JDBC 4 drivers: <SQLLIB> /java/db2jcc4.jar; <SQLLIB> /java/db2jcc_license_cu.jar


Examples: DB2 version 9.1 on Windows: C:/IBM/WebSphere/PortalExpress/db2/java/db2jcc.jar;C:/IBM/WebSphere/PortalExpress/db2/java/db2jcc_license_cu.jar:

Default: <SQLLIB> /java/db2jcc4.jar; <SQLLIB> /java/db2jcc_license_cu.jar

db2.JdbcProviderName

Description: The name of JDBC provider to be used.
Value: Alphanumeric text string
Examples: No examples are available.

Default: wpdbJDBC_db2

Oracle Database properties

The following property value pairs are specific to Oracle Database.
oracle.DbDriver

Description: The name of class SqlProcessor will use to import SQL files.
Value: class name
Examples: No examples are available.

Default: oracle.jdbc.driver.OracleDriver

oracle.DbLibrary

Description: Directory and name of the ZIP or JAR file containing JDBC driver class.
Value: directory path using the system specific file separator names. For Windows use a semicolon (;) and for UNIX use a colon (:).
Examples: No examples are available.

Default: <Oracle> /jdbc/lib/ojdbc6.jar

oracle.JdbcProviderName

Description: Name of jdbc provider to be used.
Value: Alphanumeric text string
Examples: No examples are available.

Default: wpdbJDBC_oracle

Microsoft SQL Server 2005 and 2008 properties

The following value pairs are specific to Microsoft SQL Server and can be used with either 2005 and 2008.
sqlserver2005.DbDriver

Description: Name of class the SqlProcessor will use to import SQL files.
Value: class name
Examples: The following are example driver class names:
JDBC driver provided by Microsoft: com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC driver provided by DataDirect: com.ddtek.jdbc.sqlserver.SQLServerDriver

Default: com.microsoft.sqlserver.jdbc.SQLServerDriver

sqlserver2005.DbLibrary

Description: Directory and name of the ZIP or JAR file containing JDBC driver class. Use the system specific file separator names, for Windows use a semicolon and for UNIX use a colon.
Value: Alphanumeric text string
Examples: JDBC driver provided by Microsoft: <Microsoft SQL Server JDBC Driver> /sqljdbc_2.0/enu/sqljdbc4.jar
JDBC driver provided by DataDirect: <DataDirect Connect for JDBC> /lib/sqlserver.jar

Default: <Microsoft SQL Server JDBC Driver> /sqljdbc_2.0/enu/sqljdbc4.jar

sqlserver2005.JdbcProviderName

Description: Name of JDBC provider to be used.
Value: Alphanumeric text string
Examples: No examples are available.

Default: wpdbJDBC_sqlserver2005

sqlserver2005.DbConnectionPoolDataSource

Description: Name of the implementation class of the connection pool data source.
Value: class name
Examples: The following are example connection pool data source class names:
JDBC driver provided by Microsoft: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource

JDBC driver provided by DataDirect: com.ddtek.jdbcx.sqlserver.SQLServerDataSource

Default: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource

IBM DB2 for z/OS properties

The following value pairs are specific to IBM DB2 for z/OS.
db2_zos.DbDriver

Description: Name of class SqlProcessor will use to import SQL files.
Value: Valid values include the following:
com.ibm.db2.jcc.DB2Driver


Examples: none available

Default: com.ibm.db2.jcc.DB2Driver

db2_zos.DbLibrary

Description: Directory and name of the ZIP or JAR file containing JDBC driver class. Use the system specific file separator names, for Windows use a semicolon (;) and for UNIX use a colon (:).
Value: Valid values include the following, where <SQLLIB> would be updated based on server.
DB2 on z/OS version 8.x: db2_zos.DbLibrary=/jcc/classes/db2jcc.jar:/jcc/classes/db2jcc_license_cisuz.jar:/jcc/classes/db2jcc_javax.jar

All other DB2 on z/OS versions: db2_zos.DbLibrary= <SQLLIB> /jcc/classes/db2jcc4.jar: <SQLLIB> /jcc/classes/db2jcc_license_cisuz.jar: <SQLLIB> /jcc/classes/db2jcc_javax.jar


Examples: No examples are available.

Default: <SQLLIB> /jcc/classes/db2jcc4.jar: <SQLLIB> /jcc/classes/db2jcc_license_cisuz.jar: <SQLLIB> /jcc/classes/db2jcc_javax.jar

db2_zos.JdbcProviderName

Description: Name of jdbc provider to be used.
Value: Alphanumeric text string
Examples: No examples are available.

Default: wpdbJDBC_db2_zos

db2_zos.DbNativeLibrary

Description: Required when WebSphere Portal is running on z/OS only.
Value: The directory of the native DB2 libraries
Examples: No examples are available.

Default: usr/lpp/db2/db2810/jcc/lib

db2_zos.DbSqljProperties

Description: Required when WebSphere Portal is running on z/OS only.
Value: The directory and name of the DB2 JDBC property file on z/OS
Examples: No examples are available.

Default: /etc/DB2JccConfiguration.properties

db2_zos.DbDriverType

Description: Specifies the connection type for the driver.
Value: Valid values include:
2: Type 2 local using RRS as transaction coordinator

4: Type 4 remote using J2EE XA


Examples: No examples are available.

Default: 2

IBM DB2 for i properties

The following value pairs are specific to IBM DB2 for i.
db2_iseries.DbDriver

Description: Name of class the SqlProcessor will use to import SQL files.
Value: class name
Examples: Examples are provided for both type 2 and 4 drivers:
Type 2 driver: db2_iseries.DbDriver=com.ibm.db2.jdbc.app.DB2Driver

Type 4 driver: db2_iseries.DbDriver=com.ibm.as400.access.AS400JDBCDriver

Default: com.ibm.as400.access.AS400JDBCDriver

db2_iseries.DbLibrary

Description: The directory and name of the zip/jar file containing JDBC version 4 driver class
Value: Alphanumeric text string
Examples: The following are examples:
Type 2 driver: db2_iseries.DbLibrary=/QIBM/ProdData/OS400/Java400/ext/db2_classes16.jar

Type 4 driver: db2_iseries.DbLibrary= <JDBC driver location> /jt400.jar

Type 4 driver iSeries: check the latest jt400.jar in http://sourceforge.net/projects/jt400/files/

Type 4 driver iSeries: pick the driver file with "jtopen_x_y_jdbc40_jdk6.zip". x, y: major, minor version.

Default: <JDBC driver location> /jt400.jar

db2_iseries.JdbcProviderName

Description: Name of jdbc provider to be used.
Value: Alphanumeric text string
Examples: No examples are available.

Default: wpdbJDBC_db2_iseries

db2_iseries.DbDriverType

Description: Specifies the connection type for the driver.
Value: Alphanumeric text string
Examples: Both type 2 and 4 driver examples are provided:
Type 2 driver: db2_iseries.DbDriverType=2 (local, non CCSID 65535, and non-clustered only)

Type 4 driver: db2_iseries.DbDriverType=4 (local or remote or clustered)

Default: 4

Parent

Configuration properties reference

 

+

Search Tips   |   Advanced Search