Defining a DB2 legacy CLI-based type2 JDBC driver (XA)

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:
  1. Logon to WebSphere administrative console.
  2. Click Resources → JDBC → JDBC Providers
  3. On JDBC Providers panel, select Node as scope.
  4. Click New.
  5. For Step 1: Create new JDBC provider provide the following information:
    1. Select User-defined from the Database type drop-down menu.
    2. In the Implementation class name field type: COM.ibm.db2.jdbc.DB2XADataSource
    3. In the Name field type any name to uniquely identify this JDBC driver. For example, DB2 Legacy CLI-based Type2 JDBC Driver (XA)
    4. Optional: Add a description in the Description field. For example, Custom JDBC2.0-compliant provider configuration.
  6. Click Next.
  7. For Step 2: Enter database class path information provide the path for the db2java.zip location. For example, c:\ibm\sqllib\java\db2java.zip
  8. Click Next.
  9. 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
Related concepts
Database adapter
Property extension repository adapter
Entry mapping repository adapter
Terms of use | Feedback
(C) Copyright IBM Corporation 2005. All Rights Reserved.
IBM virtual member manager 6.1