3 - Setting the WebSphere variables

  1. From the WebSphere Administrative Console window, go to Environment then to WebSphere Variables.
  2. Modify these variables:
    • Name: DB2UNIVERSAL_JDBC_DRIVER_PATH
      • Value: C:\Program Files\IBM\SQLLIB\java (or the folder where db2jcc.jar is installed)
    • Name: DB2_JDBC_DRIVER_PATH
      • Value: C:\Program Files\IBM\SQLLIB\java (or the folder where db2jcc.jar is installed)
  3. Add a new variable:
    • Name: CLOUDSCAPEV10_JDBC_DRIVER_PATH
      • Value: C:\Program Files\IBM\Cloudscape_10.0\lib
Note: For CLOUDSCAPEV10 to work, you must have the cloudscape-v10-helper.jar stored in the lib/ext of Websphere. This jar can be found in the rpm-web-services.ear. To retrieve it extract the EAR file with a Zip file extractor, this should extract the file rpm-web-services.war then extract the WAR file located in the folder /WEB-INF/lib/cloudscape-v10-helper.jar.