Skip to main content link. Accesskey S
  • Anonymous
  • Log on
  • Help
  • IBM logo
  • WebSphere Portal Family wiki
  • All Wikis
  • Home
  • Community Articles
  • Product Documentation
  • Learning Center


Search

Advanced Search

Categories

Tag Cloud

  • 6.0
  • 6.1
  • 6.1.0.1
  • 6.1.5
  • 7.0
  • 7.0.0.2
  • 8.0
  • actions
  • administrator
  • authoring
  • Banking template
  • best practices
  • blogs
  • builder
  • building a site
  • caching
  • catalog
  • Clickstream Engine
  • clusters
  • ConfigEngine tasks
  • content
  • customizing
  • databases
  • demo
  • deployment
  • deployment scenario
  • developer
  • developing
  • device class
  • elements
  • examples
  • Express
  • feature set
  • fix pack 2
  • Government to Business template
  • info center
  • information center
  • installation
  • installing
  • LDAP
  • Learning
  • libraries
  • LikeMinds Recommendation Engines
  • logging
  • mentors
  • message catalog
  • messages
  • migration
  • mobile
  • mobile devices
  • mobile experience
  • mobile experience 8.0
  • mobile theme
  • mobile webkit
  • MPA
  • multiplatform
  • pages
  • performance
  • personalization
  • planning
  • portal
  • Portal 6.1
  • Portal 8 theme
  • portlets
  • product doc
  • product documentation
  • projects
  • properties
  • Redbooks
  • Redbooks Wiki
  • remember me cookie
  • resources
  • REST
  • Retail Vendor template
  • rules
  • samples
  • search
  • security
  • sifters
  • sites
  • solutions catalog
  • syndication
  • test infrastructure
  • theme
  • theme optimization
  • topologies
  • troubleshooting
  • tutorials on personalization
  • video
  • wcm
  • web content
  • webkit
  • WebSphere Portal
  • WebSphere Portlet Factory
  • wikis
  • workflows
  • worksheet
  • XML configuration interface
  • z/os
  • zos
InformationInformation
You are currently viewing machine translated content. IBM translation might be available. Click IBM Translated Product Documentation to see what is available.X


Home > WebSphere Portal > ConfigEngine: wkplc_dbtype.properties
Rate this article 1 starRate this article 2 starsRate this article 3 starsRate this article 4 starsRate this article 5 stars

ConfigEngine: wkplc_dbtype.properties 

expanded Abstract
collapsed Abstract
No abstract provided.
ShowTable of Contents
HideTable of Contents
  • 1 Derby Properties
  • 2 DB2 Properties
  • 3 Oracle Properties
  • 4 Microsoft SQL Server 2005 Properties
  • 5 DB2_ZOS Properties
  • 6 DB2_iSeries Properties
This reference document is a based on the wkplc_dbtype.properties file included in WebSphere Portal 6.1.0.1. As needed, IBM support will make updates to this reference document to clarify usage and limitations.

The properties are organized by database type: Derby, DB2, Oracle, Microsoft SQL Server 2005, DB2 z/OS, DB2 iSeries


DbSafeMode

Description: This only applies to Database specific tasks. If it is set to true the databases will not be created, initialized, or removed.
Value: false | true
Examples: none available
Default: DbSafeMode=false

Derby Properties



derby.DbDriver

Description: The name of class SqlProcessor will use to import SQL files
Value: class name
Examples: none available
Default: derby.DbDriver=org.apache.derby.jdbc.EmbeddedDriver

derby.DbLibrary

Description: The directory and name of the zip/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 characters
Examples: none available
Default: derby.DbLibrary=C:/IBM/WebSphere/PortalExpress/AppServer/derby/lib/derby.jar

derby.JdbcProviderName

Description: The name of jdbc provider to be used.
Value: alphanumeric characters
Examples: none available
Default: derby.JdbcProviderName=wpdbJDBC_derby


DB2 Properties



db2.DbDriver

Description: The name of class SqlProcessor will use to import SQL files.
Value: class name
Examples:
  • For DB2 Type 2 driver use COM.ibm.db2.jdbc.app.DB2Driver
  • For DB2 Type 4 driver use com.ibm.db2.jcc.DB2Driver
Default: db2.DbDriver=com.ibm.db2.jcc.DB2Driver

db2.DbLibrary
Description: The directory and name of the zip/jar file containing JDBC driver class. Use system specific file separator names,for Windows use a semicolon and for UNIX use a colon.
Value: alphanumeric characters
Examples:
  • For DB2 Type 2 driver use /java/db2java.zip
  • For DB2 Type 4 driver use /java/db2jcc.jar;/java/db2jcc_license_cu.jar
Default: db2.DbLibrary=C:/IBM/WebSphere/PortalExpress/db2/java/db2jcc.jar;C:/IBM/WebSphere/PortalExpress/db2/java/db2jcc_license_cu.jar

db2.JdbcProviderName
Description: The name of jdbc provider to be used
Value: alphanumeric characters
Examples: none available
Default: db2.JdbcProviderName=wpdbJDBC_db2

Oracle Properties



oracle.DbDriver

Description: The name of class SqlProcessor will use to import SQL files
Value: class name
Examples: none available
Default: oracle.DbDriver=oracle.jdbc.driver.OracleDriver

oracle.DbLibrary

Description: The directory and name of the zip/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 characters
Examples: none available
Default: oracle.DbLibrary=/jdbc/lib/ojdbc14.jar

oracle.JdbcProviderName

Description: The name of jdbc provider to be used
Value: alphanumeric characters
Examples: none available
Default: oracle.JdbcProviderName=wpdbJDBC_oracle


Microsoft SQL Server 2005 Properties



sqlserver2005.DbDriver
Description: The name of class SqlProcessor will use to import SQL files
Value: class name
Examples:
  • JDBC driver provided by Microsoft: com.microsoft.sqlserver.jdbc.SQLServerDriver
  • JDBC driver provided by DataDirect: com.ddtek.jdbc.sqlserver.SQLServerDriver
Default: sqlserver2005.DbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver

sqlserver2005.DbLibrary
Description: The directory and name of the zip/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 characters
Examples: none available
  • JDBC driver provided by Microsoft: /sqljdbc_1.2/enu/sqljdbc.jar
  • JDBC driver provided by DataDirect: /lib/sqlserver.jar;/lib/base.jar;/lib/util.jar
Default: sqlserver2005.DbLibrary=/sqljdbc_1.2/enu/sqljdbc.jar

sqlserver2005.JdbcProviderName
Description: The name of jdbc provider to be used
Value: alphanumeric charactersExamples: none available
Default: sqlserver2005.JdbcProviderName=wpdbJDBC_sqlserver2005

sqlserver2005.DbConnectionPoolDataSource

Description: The name of the implementation class of the connection pool data source
Value: class name
Examples: none available
  • JDBC driver provided by Microsoft: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
  • JDBC driver provided by DataDirect: com.ddtek.jdbcx.sqlserver.SQLServerDataSource
Default: sqlserver2005.DbConnectionPoolDataSource=com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource

DB2_ZOS Properties



db2_zos.DbDriver

Description: The name of class SqlProcessor will use to import SQL files
Value: Valid values include the following:
  • local: db2_zos.DbDriver=com.ibm.db2.jcc.DB2Driver
  • remote (type 2): db2_zos.DbDriver=COM.ibm.db2.jdbc.app.DB2Driver
  • remote (type 4): db2_zos.DbDriver=com.ibm.db2.jcc.DB2Driver
Examples: none available
Default: db2_zos.DbDriver=com.ibm.db2.jcc.DB2Driver

db2_zos.DbLibrary

Description: The directory and name of the zip/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:
  • local: db2_zos.DbLibrary=/jcc/classes/db2jcc.jar:/jcc/classes/db2jcc_license_cisuz.jar:/jcc/classes/db2jcc_javax.jar
  • remote (type 2): db2_zos.DbLibrary=/java12/db2java.zip
  • remote (type 4): db2_zos.DbLibrary=/jcc/classes/db2jcc.jar:/jcc/classes/db2jcc_license_cisuz.jar
Examples: none available
Default: db2_zos.DbLibrary=/jcc/classes/db2jcc.jar:/jcc/classes/db2jcc_license_cisuz.jar:/jcc/classes/db2jcc_javax.jar

db2_zos.JdbcProviderName

Description: The name of jdbc provider to be used
Value: alphanumeric characters
Examples: none available
Default: db2_zos.JdbcProviderName=wpdbJDBC_db2_zos

db2_zos.DbNativeLibrary

Description: Required for portal running on z/OS only. The directory of the native DB2 libraries
Value: alphanumeric characters
Examples: none available
Default: db2_zos.DbNativeLibrary=/usr/lpp/db2/db2810/jcc/lib

db2_zos.DbSqljProperties

Description: Required for portal running on z/OS only. The directory and name of the DB2 JDBC property file on z/OS
Value: alphanumeric characters
Examples: none available
Default: db2_zos.DbSqljProperties=/etc/DB2JccConfiguration.properties

db2_zos.DbDriverType

Description:
Value: Valid values include:
  • Type 2 local using RRS as transaction coordinator
  • Type 4 remote using J2EE XA
Examples: none available
Default: db2_zos.DbDriverType=2

db2_zos.DbLocationName
Description: The DB2 location name. This is set in the DB2 installation job DSNTIJUZ
Value: alphanumeric characters
Examples: none available
Default: db2_zos.DbLocationName=LOC1

DB2_iSeries Properties



db2_iseries.DbDriver

Description: The name of class SqlProcessor will use to import SQL files.
Value: class name
Examples:
  • Type 2 driver: db2_iseries.DbDriver=com.ibm.db2.jdbc.app.DB2Driver
  • Type 4 driver: db2_iseries.DbDriver=com.ibm.as400.access.AS400JDBCDriver
Default: db2_iseries.DbDriver=com.ibm.as400.access.AS400JDBCDriver

db2_iseries.DbLibrary
Description: The directory and name of the zip/jar file containing JDBC driver class
Value: alphanumeric characters
Examples:
  • Type 2 driver: db2_iseries.DbLibrary=/QIBM/ProdData/Java400/ext/db2_classes.jar
  • Type 4 driver: db2_iseries.DbLibrary=/QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar
Default: db2_iseries.DbLibrary=/QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar

db2_iseries.JdbcProviderName
Description: The name of jdbc provider to be used
Value: alphanumeric characters
Examples: none available
Default: db2_iseries.JdbcProviderName=wpdbJDBC_db2_iseries

db2_iseries.DbDriverType

Description:
Value: alphanumeric characters
Examples:
  • 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: db2_iseries.DbDriverType=4

End of Article

expanded Article information
collapsed Article information
Category:
WebSphere Portal, WebSphere Portal Express,
Tags:
6.1, 6.1.0.1, configuration, Config, database, Portal, Portal 6.1, DB2, Oracle, MS SQL, wkplc.properties

This Version: Version 20 October 27, 2009 3:06:04 PM by DeAnna Steiner  IBMer

expanded Attachments (0)
collapsed Attachments (0)

 


expanded Versions (6)
collapsed Versions (6)
Version Comparison     
Version Date Changed by               Summary of changes
This version (20) Oct 27, 2009 3:06:04 PM DeAnna Steiner  
19 Oct 27, 2009 2:31:29 PM DeAnna Steiner  
18 Oct 22, 2009 12:28:51 PM DeAnna Steiner  
17 Oct 22, 2009 12:24:30 PM DeAnna Steiner  
16 Sep 18, 2009 4:31:27 PM DeAnna Steiner  
14 Aug 12, 2009 5:18:30 PM DeAnna Steiner  
expanded Comments (0)
collapsed Comments (0)
Copy and paste this wiki markup to link to this article from another article in this wiki.
Go ElsewhereStay ConnectedSubscribe to RSSHelpAbout
  • All Lotus and WebSphere Portal wikis
  • IBM developerWorks
  • IBM Software support
  • IBM Social Business User Experience Blog
  • IBMSocialBizUX on Twitter
  • IBMSocialBizUX on Facebook
  • Lotus product forums
  • IBM Social Business UX blog
  • IBM Collaboration Solutions
  • Recently added feedRecently added
  • Recently edited feedRecently edited
  • Recently added comments feedRecently Added Comments
  • Wiki Help
  • Forgot user name/password
  • Wiki design feedback
  • Content feedback
  • About the wiki
  • About IBM
  • Privacy
  • Contact IBM
  • IBM Terms of use
  • Wiki terms of use