On the left panel, expand Resources, and
right-click JDBC Providers.
Click New in the pop-up menu to create the new JDBC Provider.
- On the General tab:
- Type in any name, such as DB2 8.1 Type 4 Driver.
- Set the Implementation Classname to:
com.ibm.db2.jcc.DB2ConnectionPoolDataSource
- On the Nodes tab:
- Select Install New.
- Select the node to install the driver to.
- Click Specify Driver.
- Click Add Driver.
- Add ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar
where ${DB2UNIVERSAL_JDBC_DRIVER_PATH} is the DB2 directory where
these files are installed
- Click Add Driver.
- ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar
- Click Add Driver.
- ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar
- Click Set.
- Click Install.
- Click OK. The driver is created.
- Expand the tree for the newly created JDBC provider.
- Right-click Data Source.
- Click New to create new datasource and enter any name.
- In the Custom Properties for the datasource, click Add
to enter each value for the following required parameters:
- databaseName - name of DB2 database (for example sample)
- driverType - 4 (take the default)
- 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 in the following location:
Windows® platforms: C:\WINNT\system32\drivers\etc
UNIX® platforms: /etc
- user - the login user for DB2
- password - the password for this user
- Click OK to complete the configuration.
- Select the data source and click Test Connection.
|