JDBC Preferences

Applies to ReadyAPI 3.51, last modified on March 21, 2024

This topic describes the options specific to JDBC drivers and their connection string patterns.

To configure the options:

  1. Click on the ReadyAPI toolbar.

  2. Select JDBC Drivers in the left part of the ReadyAPI Preferences window and configure the needed options.

The available options and their descriptions are in the table below.

Option Description
Add Button Add a driver to the driver list.
Remove Button Remove the selected driver from the driver list.
Load Button Load driver values from an external file.
Reload Button Reload the default driver settings.

Example

Below is a sample configuration for a jTDS driver.

The jtds-x.x.x.jar file should be placed in the bin/ext directory of your ReadyAPI installation.

Add a Connection String Template

  1. Click .

    Naming the template
  2. Enter a descriptive name for the the driver. Use the following name for now: MSSQL(jTDS)/net.sourceforge.jtds.jdbc.Driver.

  3. Find the new driver in the list.

  4. Add a Connection String Template. It should look like this:

    jdbc:jtds:sqlserver://<HOST:127.0.0.1>:<PORT:1433>/<DB>;domain=yourdomain;trusted_connection=yes

    Replace yourdomain with your domain name. PORT is the port number you use to connect to the database.

See Also

Database Manager
Working With Database Drivers
Preferences

Watch the video
 
Highlight search results