How to Configure WebSphere Data Source Using DB2 Universal JDBC Driver (JCC)?
 Technote (FAQ)
 
Problem
Setting WebSphere data source for DB2 Universal JDBC Driver (JCC Driver) Type 4 using Administrative Console
 
Solution

On left hand pane, expand Resource, and click on JDBC Providers.

On the right pane, click New button to create the new JDBC Provider.

Select DB2 Universal JDBC Driver Provider from the pull-down list for the JDBC Providers and click Apply

On the Configuration tab for DB2 Universal JDBC Driver Provider, in General Properties section, provide the following information:

Classpath:


${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar

${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar

${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar

(Note: ${DB2UNIVERSAL_JDBC_DRIVER_PATH} is a WebSphere variable which should be set in Environment ---> Manage WebSphere Variables section. Full path name can be used instead of WebSphere variable)


Implementation Classname:

com.ibm.db2.jcc.DB2ConnectionPoolDataSource

(This is the default value.)


In the Additional Properties

Click Data Source

Click New to create new data source and enter the value(s) for the required parameters.

In the Custom Properties for the data source, enter the values for the following required parameters:

  • databaseName - name of DB2 database (e.g. sample)
  • driverType - 4 (should be defaulted already)
  • serverName - hostname or IP address of the DB2 Server
  • portNumber - connection port for the DB2 instance. The default value is 50000. If non-default value was used, the value can be obtained from the services file which is located at

    On Windows platforms: C:\WINNT\system32\drivers\etc.

    On UNIX platforms: /etc

 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): Windows
Software version: 5.0.2
Software edition:
Reference #: 1141286
IBM Group: Software Group
Modified date: Oct 15, 2003