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
|