This topic provides an overview of how to configure the Parasoft JDBC Driver.

Sections include:

Configuration Process

The recommended configuration process is:

1. Place the Parasoft JDBC Driver jar file on the application server (the following sections indicate exactly where it should be placed on each type of server). The driver, ParasoftJDBCDriver.jar, ships with Parasoft Virtualize under <INSTALL-DIR>/proxies.
2. Configure the driver to register with the appropriate Virtualize Server. The method for configuring the Parasoft JDBC Driver varies depending on how your application is deployed. For details on how to perform the configurations appropriate for your specific environment, see:
   • Configuration on WebSphere Application Servers
   • Configuration on webMethods Integration Servers
   • Configuration on TIBCO ActiveMatrix BusinessWorks
   • Configuration on Oracle/BEA WebLogic 9.2 Application Servers
   • Configuration on Oracle WebLogic 10.3 (11g) Application Servers
   • Configuration on Apache Tomcat Application Servers
   • Configuration on JBoss Application Servers
   • JDBC Configuration for Standalone or Other Application Server Platforms
   • JDBC Configuration for ParaBank
3. Start the application under test (AUT). When the driver is initialized, it will automatically connect to Virtualize and either create a new deployment configuration for that group ID or get settings from an existing deployment configuration with the same group ID. The Console view will report a message that the driver is registered:
   
4. Verify that the JDBC Controller for this Parasoft JDBC Driver appears in the Virtualize Server view.
   

From that point forward, you will be able to control the JDBC driver mode and logging via the Virtualize Server view or Environment Manager. By default, the driver starts in passthrough mode with log level 1.

Driver/System Properties Required for All Environments

For all application servers and setups, you must configure the following two driver properties for the Parasoft JDBC Driver: 

• virtualizeServerUrl: Specifies the hostname of Parasoft Virtualize Server. This should have the format http://<VIRTUALIZE SERVER HOST NAME/IP ADDRESS>:9080. Port number 9080 is the default. Use a port number other than 9080 only if Virtualize Server has been configured with a different port number.
• virtualizeGroupId: The group name used to create the JDBC Controller in Virtualize. Multiple drivers may share the same group ID. All drivers that share a single group ID will all be updated by any configuration changes made from the related controller. For example, if you have a cluster of nodes and want to be able to start or stop recording in unison, configure them share a single group ID. If you want to control them individually, assign them each a distinct group ID.
  • If you use an existing group ID, the current Parasoft JDBC Driver will be assigned to that group’s JDBC Controller.
  • If you use a new group ID, a new JDBC Controller will be created for that new group ID.

The following Java system properties are required startup parameters for the AUT:

• parasoft.virtualize.group.id: The equivalent of the virtualizeGroupId driver property; the default is hostname.
• parasoft.virtualize.server.url: The equivalent of the virtualizeServerUrl driver property.

These properties can be set as part of the driver URL. For example, the following sets the group ID and server URL:

jdbc:parasoft:proxydriver:virtualizeGroupId=derbyTest&virtualizeServerPath=MyPath:@org.apache. derby.jdbc.EmbeddedDriver:@jdbc:derby:memory:myDB;create=true

Alternatively, you can usually specify these either through the Admin GUI or as command-line arguments to Java using the –D<PROP NAME>=<PROP VALUE> syntax.

To see the exact system properties that your AUT needs to use, see Parasoft Environment Manager’s endpoint report. For example: 
 

Specifying which Virtual Asset the Parasoft JDBC Driver Calls

By default, the Parasoft JDBC Driver calls the virtual asset deployed at /virtualDb (when in Virtualize or Hybrid mode or in Failover mode and a failure occurs). To have it call a virtual asset that is deployed at a different endpoint, use the optional driver/system property:

• Driver property for all application servers and setups: virtualizeServerPath
• Java System property: parasoft.virtualize.server.path

This property should be set to the virtual asset deployment configuration path. For example, if your virtual asset is deployed at /myVirtualDb, you would configure this in either of the following ways:

parasoft.virtualize.server.path=myVirtualDb

or

virtualizeServerPath=myVirtualDb

Controlling Polling Intervals

The default (poall) provider uses a simple HTTP connection to check whether any Parasoft JDBC Driver updates (for example, JDBC driver mode changes) have been set in the Virtualize Server view.

The default polling interval is 5000 ms. If you want to change the polling frequency, use the system property parasoft.virtualize.poll.

Migration for Users of Virtualize 9.4 or Earlier

If you’ve used a version of the Parasoft JDBC Driver from Virtualize 9.4 or earlier, take the following steps to start using the latest functionality:

1. Update your existing Parasoft JDBC Driver jar file (ParasoftJDBCProxy-All.jar) to the new ParasoftJDBCDriver.jar, which is under [virtualize installation directory]/proxies).
2. Update your driver properties by a) removing all virtualize* properties EXCEPT for virtualizeServerUrl, then b) adding virtualizeGroupId. This specifies the group name used to create the JDBC Controller in Virtualize. Multiple drivers may share the same group id and will all be updated by any configuration changes made. If you use an existing group id, the current driver will be assigned to that group and the associated JDBC Controller. If you use a new group id, a new configuration and JDBC Controller will be created for that new group id. 
   
   In Virtualize 9.4 or earlier:
   
   
   
   In Virtualize 9.5 and higher:
   
   
   
   

3. Update your AUT’s startup parameters by a) Removing all parasoft.virtualize* properties EXCEPT for parasoft.virtualize.server.url and—if used—parasoft.virtualize.driver.proxy.direct and parasoft.virtualize.driver.register.jdbcproxydriver.in.drivermanager and then b) Adding parasoft.virtualize.group.id.

   In Virtualize 9.4 or earlier:

   set JAVA_OPTIONS=%JAVA_OPTIONS% 
   -Dparasoft.virtualize.mode=record 
   -Dparasoft.virtualize.log.destination=file 
   -Dparasoft.virtualize.log.level=1 
   -Dparasoft.virtualize.log.file.location=[desired path]/jdbcproxy.log 
   -Dparasoft.virtualize.server.url=http://VirtualizeServerHostName:9080 
   -Dparasoft.virtualize.driver.proxy.direct=false 
   -Dparasoft.virtualize.driver.register.jdbcproxydriver.in.drivermanager=true

   
   In Virtualize 9.5 and higher:

   set JAVA_OPTIONS=%JAVA_OPTIONS% 
   -Dparasoft.virtualize.group.id=ParaBank 
   -Dparasoft.virtualize.server.url=http://VirtualizeServerHostName:9080 
   -Dparasoft.virtualize.driver.proxy.direct=false 
   -Dparasoft.virtualize.driver.regis-ter.jdbcproxydriver.in.drivermanager=true