JDBC agent settings

This dialog box enables you to configure the Service Virtualization JDBC agent. The agent handles communication between a client and a real or virtual service.

To access
  1. From the main menu, select Tools > Options.
  2. Click Agents.
  3. Under JDBC, select a configuration.
Important information
  • For additional important configuration information, see the task Configure the JDBC agent.
  • You can define multiple configurations for each agent.
Relevant tasks
See also Service Virtualization agents

User interface elements are described below (unlabeled elements are shown in angle brackets):

UI Element Description
<left pane>

Displays the server configured for your project.

Expand the server to display the available agents and configurations.

Add

Enables you to define additional configurations of the agent.

Delete Deletes the selected configuration.
Duplicate

Creates an additional configuration of the agent by copying the selected configuration. You can then modify the configuration settings.

Note: By default, the configuration is created with a sequential unoccupied port number.

Export

Saves the selected agent configuration as a file. The file is saved in the .agce file format, and can be imported to any Service Virtualization Server.

Export All Exports all agent configurations on the selected server. The file is saved in the .agce file format, and can be imported to any Service Virtualization Server.
Import

Enables you to select an exported agent configuration file stored on the file system. The file is saved in the .agce file format, and can be imported to any Service Virtualization Server.

If the configuration file you are importing contains multiple configurations, you can select which configurations you want to import.

If you choose to import an agent configuration that is identical to a configuration that already exists on your server, you can choose to overwrite your existing configuration, or create a new, additional configuration.

Agent State The current status of the agent. Values include Running, Not Running.
Test Configuration link

Tests the configuration based on the settings you select. If Service Virtualization identifies any problems in your configuration, the details are displayed.

Is Enabled Turns the selected configuration of the agent on and off.

Name

Enter a name for the configuration or accept the default name.

Host/Port The machine and port on which the JDBC agent is listening. Required for communication with the JDBC driver installed on the application under test.
Actual JDBC Driver Class Name

The fully qualified class name of the actual driver used in the application under test. Enter the name or select one from the list.

Available only when you select JDBC Version 3.0.

Deployment Type

The environment in which your application under test is running.

  • If your application under test is deployed on a J2EE application server, select the appropriate version from the drop-down list.
  • For a Java standard edition application, select J2SE.
JDBC Version

The JDBC version used by the application under test.

Available only when you select J2SE in the Deployment Type field.

Create JDBC driver for this configuration

Creates the JDBC driver specific to your configuration. Specify a location for saving the files.

If you change configuration settings, you must create a new driver.

Use SSL Enables SSL over TCP/IP for communication between the JDBC driver and SV. If enabled, you must provide certificate file and password details.
Certificate File

The path to the server side certificate file, in P12 format, that is to be used by the gateway agent during an SSL handshake.

The certificate is used as the server certificate on the listening port if the Use SSL option is enabled. It is bound to the port during the startup of the agent.

Note: When remotely configuring a Service Virtualization Server's agent from the Designer, make sure that the path to the certificate is valid on the server machine on which the agent will run.

Certificate Password The password used to access the certificate file specified in the Certificate File field.
Validate Certificate Instructs the JDBC driver to validate the certificate. If this option is enabled, you will need to generate a new JDBC driver if the certificate is updated.

Back to top