JDBC Preferences

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

To configure the options:

  1. Click preferences-b.png 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.png

Add a driver to the driver list.

remove.png

Remove the selected driver from the driver list.

load-from-file.png

Load driver values from an external file.

Reload

Reload the default driver settings.

Example

Below is a sample configuration for a jTDS driver.

Important

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 add.png.

    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

Publication date: