Updating the Oracle JDBC driver

If the service level of Oracle has changed for any reason, for example, if you have applied a fix pack, you need to ensure that the Oracle JDBC driver is compatible. If necessary, follow the procedures in this section to update your Oracle JDBC driver.

To replace the Oracle JDBC driver:

If you are changing the Oracle JDBC driver, and the directory and the full path name to the driver file will remain the same, do the following:

  1. Stop the WebSphere Partner Gateway Console, Receiver, and Document Manager.
  2. Replace the Oracle JDBC driver file.
  3. Start the WebSphere Partner Gateway Console, Receiver, and Document Manager.

If you are replacing the Oracle JDBC driver and the full path name of the driver file changes, then do the following:

  1. Stop the WebSphere Partner Gateway Console, Receiver, and Document Manager.
  2. For each component, the Console, the Receiver, and the Document Manager, remove the existing JDBC datasource using bcgdatabase.jacl.

    Remove the JDBC datasource. To call information from bcgdatabase.jacl, enter the following command:

    Note:
    For Windows, replace the .sh file extension with .bat.
    ./bcgwsadmin.sh -f bcgdatabase.jacl -conntype NONE uninstall
    [db2 | oracle] <nodeName> <serverName>

    Use the following values:

    ./bcgwsadmin.sh -f bcgdatabase.jacl -conntype NONE uninstall
    oracle DefaultNode <bcgconsole, bcgreceiver, or bcgdocmgr>
  3. For each component (Console, Receiver, and Document Manager) create the JDBC datasource by calling bcgdatabase.jacl.
    ./bcgwsadmin.sh -f bcgdatabase.jacl -conntype NONE
     install <dbType> <dbName> <dbHostname> <dbPort> <dbUserId>
    <dbPassword> <nodeName> <serverName> <dbZipFile> <jndiName>

    Remember to replace the values in <> with values specified during your installation.

  4. When installing using the file produced by the Oracle option, dbZipFile is the full pathname of the Oracle JDBC driver that should be used to connect to the database. Enter the following:
    ./bcgwsadmin.sh -f bcgdatabase.jacl -conntype NONE install oracle
    <dbName> <dbHostname> <dbPort> <dbUserId> <dbPassword>
    DefaultNode server1 <dbZipFile> datasources/OracleDS
  5. Start the Console, Receiver and Document Manager.

Copyright IBM Corp. 2003, 2005