Properties file: wkplc_dbtype.properties

Database safe mode properties
Derby properties
IBM DB2 Database properties
Oracle Database properties
Microsoft SQL Server 2005 and 2008 properties
IBM DB2 for z/OS properties
IBM DB2 for IBM i properties

1. Database safe mode properties

DbSafeMode

Description: Can help prevent unintentional database creation, initialization and removal. It only applies to database specific tasks.
Default value: false
Examples: None available

2. Derby properties

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

derby.DbDriver

Description: The database driver used to connect to the Derby database.
Default value: org.apache.derby.jdbc.EmbeddedDriver
Examples: org.apache.derby.jdbc.EmbeddedDriver

derby.DbLibrary

Description: The directory and name of the .zip or JAR file containing the JDBC driver class.
Default value: AppServer/derby/lib/derby.jar
Examples: Linux: /opt/IBM/WebSphere/AppServer/derby/lib/derby.jar; Windows: C:/IBM/WebSphere/PortalExpress/AppServer/derby/lib/derby.jar

derby.JdbcProviderName

Description: The name of JDBC provider to be used.
Default value: wpdbJDBC_derby
Examples: None available

3. IBM DB2 Database properties

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

db2.DbDriver

Description: The database driver class name for IBM DB2:
Default value: com.ibm.db2.jcc.DB2Driver
Examples: 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 characters. For Windows use a semicolon (;) and for UNIX use a colon (:).
Default value: SQLLIB/java/db2jcc4.jar;SQLLIB/java/db2jcc_license_cu.jar
Examples: DB2 (Windows): C:/IBM/SQLLIB/java/db2jcc4.jar;C:/IBM/SQLLIB/java/db2jcc_license_cu.jar:; DB2 (UNIX): /opt/IBM/SQLLIB/java/db2jcc4.jar:/opt/IBM/SQLLIB/java/db2jcc_license_cu.jar:

db2.JdbcProviderName

Description: The name of JDBC provider to be used.
Default value: wpdbJDBC_db2
Examples: None available

4. Oracle Database properties

The following property value pairs are specific to Oracle Database.

oracle.DbDriver

Description: The database driver class name for the Oracle Database.
Default value: oracle.jdbc.OracleDriver
Examples: None available

oracle.DbLibrary

Description: The directory and name of the .zip file or JAR file containing JDBC driver class.
Default value: Oracle/jdbc/lib/ojdbc6.jar
Examples: None available

oracle.JdbcProviderName

Description: The name of JDBC provider to use.
Default value: wpdbJDBC_oracle
Examples: None available

5. Microsoft SQL Server 2005 and 2008 properties

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

sqlserver2005.DbDriver

Description: The driver class name to use for Microsoft SQLServer
Default value: com.microsoft.sqlserver.jdbc.SQLServerDriver
Examples: JDBC driver provided by Microsoft: com.microsoft.sqlserver.jdbc.SQLServerDriver; JDBC driver provided by DataDirect: com.ddtek.jdbc.sqlserver.SQLServerDriver

sqlserver2005.DbLibrary

Description: The 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 (:).
Default value: Microsoft SQL Server JDBC Driver/sqljdbc_2.0/enu/sqljdbc4.jar
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

sqlserver2005.JdbcProviderName

Description: The name of JDBC provider to be used.
Default value: wpdbJDBC_sqlserver2005
Examples: None available

sqlserver2005.DbConnectionPoolDataSource

Description: The name of the implementation class of the connection pool data source.
Default value: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
Examples: JDBC driver provided by Microsoft: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource; JDBC driver provided by DataDirect: com.ddtek.jdbcx.sqlserver.SQLServerDataSource

6. IBM DB2 for z/OS properties

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

db2_zos.DbDriver

Description: The DB2 for z/OS database driver class name
Default value: com.ibm.db2.jcc.DB2Driver
Examples: None available

db2_zos.DbLibrary

Description: The 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 (:).
Default value: SQLLIB/jcc/classes/db2jcc4.jar:SQLLIB/jcc/classes/db2jcc_license_cisuz.jar:SQLLIB/jcc/classes/db2jcc_javax.jar
Examples: None available

db2_zos.JdbcProviderName

Description: The name of JDBC provider to be used.
Default value: wpdbJDBC_db2_zos
Examples: None available

db2_zos.DbNativeLibrary

Description: Required when WebSphere Portal is running on z/OS only.
Default value: /usr/lpp/db2910_jdbc/lib
Examples: None available

db2_zos.DbSqljProperties

Description: Required when WebSphere Portal is running on z/OS only.
Default value: /etc/DB2JccConfiguration.properties
Examples: None available

db2_zos.DbDriverType

Description: The connection type for the driver.
Default value: 2
Examples: None available

7. IBM DB2 for IBM i properties

db2_iseries.DbDriver

Description: The database driver class name for DB2 iSeries
Default value: com.ibm.as400.access.AS400JDBCDriver
Examples: None available

db2_iseries.DbLibrary

Description: The directory and name of the .zip or JAR file containing JDBC version 4 driver class
Default value: JDBC driver location/jt400.jar
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 for IBM i: check the latest jt400.jar in http://sourceforge.net/projects/jt400/files/; Type 4 driver for IBM i: seelct the driver file with "jtopen_x_y_jdbc40_jdk6.zip". x, y: major, minor version.

db2_iseries.JdbcProviderName

Description: The name of JDBC provider to be used.
Default value: wpdbJDBC_db2_iseries
Examples: None available

db2_iseries.DbDriverType

Description: The following value pairs are specific to IBM DB2 for IBM i.
Default value: 4
Examples: None available