Removing JDBC proxy from WebSphere® Application Server

After testing is complete, you can remove the JDBC proxy from the IBM® WebSphere® Application Server instance.

Before you begin

JDBC data sources must be disabled in HCL DevOps Test Integrations and APIs (Test Integrations and APIs). For details, see Selecting and enabling JDBC data sources in WebSphere Application Server.

About this task

The steps assume the Green Hat JDBC Provider is installed.

Procedure

  1. Note the location of the uninstallJDBCProvider.py script file on the server as "Server_JDBC_installation_location".
  2. Open a command prompt and navigate to the following directory:
    <WebSphere Application Server installation directory>\AppServer\profiles\<Profile name>\bin
    Note: For Unix-like installations, forward slashes ("/") are instead of backslashes ("\").
  3. Remove the Green Hat JDBC Provider by running a command in the following format:

    wsadmin.bat -f Server_JDBC_installation_location/uninstallJDBCProvider.py node Node_name | node Node_name server Server_name | cluster Cluster_name

    Note: For Microsoft Windows, and Unix-like installations, use the forward slash (/) instead of the backslash (\) for this command. In addition, for Unix-like installations, use wsadmin.sh instead of wsadmin.bat.

Results

The Green Hat JDBC Provider is removed. To verify this, log in to the WebSphere® Integrated Solutions Console by using the relevant profile, and click Resources > JDBC > JDBC providers.

The Green Hat JDBC Provider should no longer be displayed.

Example

To remove the JDBC provider from every server, node, and cluster in the WebSphere® Application Server cell, run the following command:

wsadmin.bat -f Server_JDBC_installation_location/uninstallJDBCProvider.py

To remove the JDBC provider from a single node, run the following command:

wsadmin.bat -f Server_JDBC_installation_location/uninstallJDBCProvider.py node Node_name

To remove the JDBC provider from a single server, run the following command:

wsadmin.bat -f Server_JDBC_installation_location/uninstallJDBCProvider.py node Node_name server Server_name

To remove the JDBC provider from a cluster, run the following command:

wsadmin.bat -f Server_JDBC_installation_location/uninstallJDBCProvider.py cluster Cluster_name