Deploying JDBC proxy into Software AG webMethods Integration Server

The JDBC proxy must be deployed on each application server that is running webMethods Integration Server (WMIS). The JDBC proxy enables a server that hosts applications to use JDBC to access a live database that you want to record or virtualize.

About this task

Important: Differences between WMIS 7.x/8.0 and WMIS 8.2 (or later) are indicated where relevant.

After you install the Rational® Integration Tester webMethods Integration Server adapter package, deploy the JDBC proxy into WMIS:

Procedure

  1. Download and extract the JDBC driver package that is provided with Rational Test Control Panel. For more information, see Rational Integration Tester tool packages.
  2. Copy the files that are listed in the following table Testing Java applications that use JDBC from the downloaded JDBCIntercept.zip package to <Software AG installation directory>\IntegrationServer\lib\jars or to whichever WMIS folder that contains JDBC drivers.
    JDBC / Java™ version File name Description
    JDBC 3, Java 1.5 greenhat.jdbcdriver.jar The JDBC proxy.
    JDBC 4, Java 1.6 com.ibm.rational.rit.jdbcdriver4.jar The JDBC proxy.
    All versions jsqlparser15.jar and antlr-3.4.jar
    Note: The following items are not supported for vendor-specific Oracle SQLs:
    • Oracle-specific DDL statements
    • Custom functions
    • Subqueries
    • PIVOT and UNPIVOT statements
    • Nested tables containing multiple columns or single column of user-defined-types
    • Stubs with nested tables
    		 Supporting libraries.
    File name Description
    registration.xml JDBC proxy configuration file.
  3. Configure the server start script (Software AG installation directory\IntegrationServer\bin\server.bat) as follows:
    WMIS 7.x/8.0 WMIS 8.2 and later
    Change %JAVA_RUN% -DWM_HOME= to 
    %JAVA_RUN% -Djbdc.drivers=com.greenhat.jdbc.Driver -DWM_HOME=
    		 Change SET JAVA_OPTS=-Dsun.lang.classLoader to 
    SET JAVA_OPTS=-Djdbc.drivers=com.greenhat.jdbc.Driver -Dsun.lang.classLoader
    Note: If the server.bat file does not have the JAVA_OPTS environment variable, add the line 
    SET JAVA_OPTS=-Djdbc.drivers=com.greenhat.jdbc.Driver
    to the file.
    Tip: For Linux or UNIX installations, use server.sh, forward slashes ("/") instead of backslashes ("\"), and the appropriate Linux or UNIX directory names.
  4. Save and close the file.
  5. If necessary, edit the server tag in the registration.xml file to the URL of the IBM® Rational Test Control Panel installation that is being used.

    For information about modifying this file, see Modifying the configuration settings of the JDBC proxy.

  6. Optional: Edit the domain and environment tags in the registration.xml file.
    Important: If these tags are modified, the JDBC Proxy is used only when you record and stub within the specified domain and environment.
  7. Use IBM Rational Integration Tester and Rational Test Control Panel to control JDBC recording and stubbing. For more information, see Rational Integration Tester reference and Virtualization testing using Rational Test Virtualization Server.
Feedback