Forum Discussion

markgholland's avatar
markgholland
Occasional Contributor
9 years ago
Solved

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 in my \bin\ext directory)

 

I guess I should start with a question....

  1. What is the "correct" way of adding a DB connection to a specific environment? If I want my JDBC request to automatically select a specific DB connection without having to update my test step when switching from dev1 to dev2, how do I do that?
    • My experience so far has been when I add a database connection, it adds it to all my environments.
  2. I need to connect to the DBs via a service name instead of a SID (yes, I've queried the DB and attempted to use the SID, but it doesn't work).  I've modified the DB connection syntax and can connect to the DB, but how do I make the ReadyAPI form ask for a service name instead of a SID?
    • I've attempted to modify the template under Preferences > JDBC drivers, but I just may be using the incorrect format? Notice the slash between the port and the service name....
      • Template: jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1521>/<SERVICE_NAME?>
  3. I'm also seeing some oddness when it comes to deleting database connections... I know, a lot of detail here, but just wondering if anyone else is having issues with database connections in general?