+

Search Tips   |   Advanced Search

Properties file: wkplc_dbtype.properties


Table of contents

  1. Database safe mode properties
  2. Derby properties
  3. IBM DB2 Database properties
  4. Oracle Database properties
  5. Microsoft SQL Server 2005 and 2008 properties
  6. IBM DB2 for z/OS properties
  7. IBM DB2 for IBM i properties


Parent: Configuration properties reference


1. Database safe mode properties


DbSafeMode

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


2. Apache Derby properties


derby.DbDriver

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

derby.DbLibrary

Description Path to the.zip or JAR file containing the JDBC driver class.
Default 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 wpdbJDBC_derby
Examples None available


3. IBM DB2 Database properties


db2.DbDriver

Description The database driver class name for IBM DB2:
Default com.ibm.db2.jcc.DB2Driver
Examples com.ibm.db2.jcc.DB2Driver

db2.DbLibrary

Description Path to 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 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 wpdbJDBC_db2
Examples None available


4. Oracle Database properties


oracle.DbDriver

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

oracle.DbLibrary

Description Path to the.zip file or JAR file containing JDBC driver class.
Default Oracle/jdbc/lib/ojdbc6.jar
Examples None available

oracle.JdbcProviderName

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


5. Microsoft SQL Server 2005 and 2008 properties


sqlserver2005.DbDriver

Description The driver class name to use for Microsoft SQLServer
Default 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 Path to 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 Microsoft SQL Server JDBC Driver/sqljdbc_2.0/enu/sqljdbc4.jar
Examples Microsoft SQL Server: /sqljdbc_2.0/enu/sqljdbc4.jar
DataDirect Connect: /lib/sqlserver.jar

sqlserver2005.JdbcProviderName

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

sqlserver2005.DbConnectionPoolDataSource

Description The name of the implementation class of the connection pool data source.
Default 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


db2_zos.DbDriver

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

db2_zos.DbLibrary

Description Path to 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 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 wpdbJDBC_db2_zos
Examples None available

db2_zos.DbNativeLibrary

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

db2_zos.DbSqljProperties

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

db2_zos.DbDriverType

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


7. IBM DB2 for IBM i properties


db2_iseries.DbDriver

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

db2_iseries.DbLibrary

Description Path to the.zip or JAR file containing JDBC version 4 driver class
Default 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 wpdbJDBC_db2_iseries
Examples None available

db2_iseries.DbDriverType

Description Specific to IBM DB2 for IBM i.
Default 4
Examples None available