DB2 legacy CLI-based type2 JDBC Driver (XA) is deprecated in WebSphere
Application Server 6.1 and it is not presented as one of the options for JDBC
providers. Virtual member manager database, property extension and entry
mapping repositories need this DB2 driver to operate correctly.
Follow these steps to create a user-defined JDBC driver for DB2 Legacy
CLI-based Type2 driver:
- Logon to WebSphere administrative console.
- Click Resources → JDBC → JDBC Providers
- On JDBC Providers panel, select Node as scope.
- Click New.
- For Step 1: Create new JDBC provider provide the following
information:
- Select User-defined from the Database type drop-down
menu.
- In the Implementation class name field type: COM.ibm.db2.jdbc.DB2XADataSource
- In the Name field type any name to uniquely identify this JDBC
driver. For example, DB2 Legacy CLI-based Type2 JDBC
Driver (XA)
- Optional: Add a description in the Description field. For example, Custom JDBC2.0-compliant provider configuration.
- Click Next.
- For Step 2: Enter database class path information provide
the path for the db2java.zip location. For example, c:\ibm\sqllib\java\db2java.zip
- Click Next.
- For Step 3: Summary verify the information and click Finish.
Now this newly created JDBC provider is presented in the provider
list that you can select to configure the DataSources