JDBC Preferences

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

To configure the options:

Click on the ReadyAPI toolbar.
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 a driver to the driver list.

Remove the selected driver from the driver list.

Load driver values from an external file.

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.

Click .
Enter a descriptive name for the the driver. Use the following name for now: MSSQL(jTDS)/net.sourceforge.jtds.jdbc.Driver.
Find the new driver in the list.
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.