Oracle JDBC Driver

Applies to ReadyAPI 3.9, last modified on July 16, 2021

The Oracle JDBC driver provides connections for the Oracle databases.

To install the driver, do the following:

  1. Download the Oracle database JDBC driver.

  2. Extract the archive file.

  3. Copy the ojdbc8.jar file to the <ReadyAPI installation>/bin/ext.

  4. Restart ReadyAPI to load the driver.

Connection String Template

ReadyAPI has preconfigured connection string for the Oracle database. If you need a custom one, add it by using the ReadyAPI Preferences menu:

  1. Click Preferences on the toolbar.

  2. Open the JDBC Drivers settings.

  3. Click .

  4. Enter a descriptive name, for example: Oracle/oracle.jdbc.driver.OracleDriver.

    The new connection will appear at the end of the list.

    ReadyAPI: The new connection in the JDBC connections list

    Click the image to enlarge it.

  5. Add a connection string template, for example:

    jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1521>:<SID>
    ReadyAPI: The new connection with the connection string

    Click the image to enlarge it.

To connect to the Oracle database by using Kerberos authentication, do the following:

  1. Create a Kerberos configuration file:

    krb5.conf

    [libdefaults]
    default_realm = DB.EXAMPLE.NET
    udp_preference_limit = 1

    [realms]
    DB.EXAMPLE.NET = {
        kdc = YOUR-DB-KEY-DISTRIBUTION-CENTER-SERVER
        default_domain = db.example.net
    }

    [domain_realm]
    db.example.net=DB.EXAMPLE.NET

    If you use Kerberos to authenticate your requests, you need to add a new realm to the file. See the Kerberos documentation for details.

  2. Run the kinit utility to get a ticket-granting ticket. You can find this utility in the <ReadyAPI>/jre/bin directory.

    After you specify the password, the utility will create and cache a ticket-granting ticket. Remember the path to the cache file.

    The generated ticket has an expiration date. To check whether a ticket has expired or not, use the klist utility that is located in the <ReadyAPI>/jre/bin directory.
  3. Add the following parameters to the Java virtual machine:

    JVM Settings

    ‑Djava.security.krb5.conf=<Path to the Kerberos configuration file>\krb5.conf
    ‑Doracle.net.authentication_services=(KERBEROS5)
    ‑Doracle.net.kerberos5_mutual_authentication=true
    ‑Doracle.net.kerberos5_cc_name=<Path to the ticket-granting ticket>

    The way you do this depends on how you run ReadyAPI. See Modifying JVM Settings.

See Also

Installing Database Drivers

Highlight search results