Forum Discussion

markgholland's avatar
markgholland
Occasional Contributor
9 years ago

Databases for Environments, JDBC Driver Connection String Templates

I'm seeing some *odd* things when attempting to add database connections to my project... Here are the details: Mac OS X ReadyAPI 1.7.0 Oracle 11g/12c databases OracleThin JDBC driver (located i...
  • markgholland's avatar
    markgholland
    9 years ago

    Using project level properties worked!  Thanks for the assitance!

     

    For reference, I removed all "Databases" from the project.  Below is an example of my JDBC Test Step:

    The connection string was cut off in the screenshot, so this is the full line:

    jdbc:oracle:thin:${#Project#dbusername}/${#Project#dbpassword}@${#Project#dbhost}:${#Project#dbport}/${#Project#dbservicename}

     

    NOTE:  The "/" after the port number is what tells the driver to connect via a service name instead of the SID.

     

    Under environments, populate the values for each property with the environment specific value:

    I hope this helps someone in the future!

nmrao's avatar
nmrao
Champion Level 3
9 years ago
I guess you need to use property expansion in the connection string.

Use project properties to define host, port and user credentials.

So, that you can simply modify the property value. When you running commandline, values can be overriden using -P<projectPropertyName>=<value> without even modifying the project.
  • markgholland's avatar
    markgholland
    Occasional Contributor
    9 years ago

    Using project level properties worked!  Thanks for the assitance!

     

    For reference, I removed all "Databases" from the project.  Below is an example of my JDBC Test Step:

    The connection string was cut off in the screenshot, so this is the full line:

    jdbc:oracle:thin:${#Project#dbusername}/${#Project#dbpassword}@${#Project#dbhost}:${#Project#dbport}/${#Project#dbservicename}

     

    NOTE:  The "/" after the port number is what tells the driver to connect via a service name instead of the SID.

     

    Under environments, populate the values for each property with the environment specific value:

    I hope this helps someone in the future!