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/ext directory of your ReadyAPI installation.
Restart ReadyAPI to load the driver.
|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 Using 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:
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.