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.
Install third-party JDBC drivers
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/ext directory 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.
Install the MySQL JDBC driver
To learn how to properly install and configure the MySQL JDBC driver, see the corresponding topic.
Choose a driver for MS SQL databases
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.
Install the Oracle JDBC driver
To learn how to properly install and configure the Oracle JDBC driver, see Oracle JDBC Driver.
See Also
JDBC Preferences
Database Manager
Use JDBC Drivers From Scripts
Data Sources and Data-Driven Tests