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. Follow the procedures in this section to update your Oracle JDBC driver if necessary.

To replace the Oracle JDBC driver:

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

  1. Stop the Business Integration Connect Console, Receiver, and Document Manager.
  2. Replace the Oracle JDBC driver file, classes12.zip.
  3. Start the Business Integration Connect 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 Business Integration Connect 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:


    ./wsadmin.sh -f bcgdatabase.jacl -conntype NONE uninstall [db2 | oracle]

    <nodeName> <serverName>

    Use the following values:


    ./wsadmin.sh -f bcgdatabase.jacl -conntype NONE uninstall oracle

    DefaultNode server1

  3. For each component, the Console, the Receiver, and the Document Manager, create the JDBC datasource by calling bcgdatabase.jacl.

    Create the JDBC datasource. To call information from bcgdatabase.jacl:


    ./wsadmin.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. Typically, the file name is classes12.zip.

    ./wsadmin.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, 2004