Before working with databases in ReadyAPI, you have to establish a database connection. For this, you use the connection drivers. You can install Postgres JDBC4 Driver or Microsoft JDBC Driver during the ReadyAPI installation.
To install a third-party JDBC driver, do the following:
Download and install the needed JDBC driver package.
Put the driver files in the
bin/extdirectory of your ReadyAPI installation.Restart ReadyAPI to load the driver.
In ReadyAPI, go to Preferences > JDBC Drivers and add the new connection template.
Tip
ReadyAPI has preconfigured connection string templates for a number of JDBC drivers.
Once you have prepared the driver and connection string, you will be able to add the database connection.
To learn how to use a Groovy script to register the JDBC driver, see Use JDBC Drivers From Scripts.
To learn how to properly install and configure the MySQL JDBC driver, see the corresponding topic.
Currently, ReadyAPI supports two connection drivers for MS SQL databases:
Microsoft SQL JDBC driver – a database connection driver published and supported by Microsoft.
JTDS driver – an open-source driver published under the GNU LGPL license by The JTDS Project.
We recommend using the Microsoft SQL JDBC driver: it is compatible with ReadyAPI and supports all necessary features. Use the JTDS driver if your database connection requires its specific properties.
To learn how to properly install and configure the Oracle JDBC driver, see Oracle JDBC Driver.