Forum Discussion

abbas's avatar
abbas
Occasional Contributor
9 years ago

Connection to an Oracle database without CID, but with Servicename

Hi everybody, I cann't configure the connection to Oracle database, because there is no CID. I must configure it just with servicename! Thanks for your support. Abbas
dd1984's avatar
dd1984
Occasional Contributor

Hi,

 

thank you !!!!! It's working  :)

 

Your solution is working for me but it's limiting me to test one database only. I have multiple environments and different service name for each data base.

 

Please suggest how to manage that.

 

Best regards,

JKambli's avatar
JKambli
Staff
9 years ago

If in a single Environment, if you use 1 database connection then on Databases tab > add 1 connection string.

http://readyapi.smartbear.com/readyapi/databases/start

 

Once you do that go to Environments > Add environment > JDBC connection > Edit the connection string for that environment. 

  • dd1984's avatar
    dd1984
    Occasional Contributor
    9 years ago

    Hi,

     

    I tried that but it's over riding the value of connection string i used in Environments with the connection String in JDBC driver.

     

    Here is the set up for oracle.jdbc.driver.OracleDriver 

     

    1.Under preferences used jdbc:oracle:thin:<username>/<pwd>:host:port/servicename   --service name say sampleTest1.se

    2.Created single database entry in Databases jdbc:oracle:thin:<username>/<pwd>:host:port/sampleTest1.se

    3.Create a test environement test  with database where service name is same as i setup in preferences >JDBC driver

    jdbc:oracle:thin:<username>/<pwd>:host:port/sampleTest1.se   --works fine 

    4.Create a test environement test 2 with database where service name is different say sampleTest2.se    --being override with sampleTest1.se

     

    So now service name in database string of  4th from above is being override by the service name i have used in 1st step above.

     

    Please confirm if i missed anything.

     

    Thank you!!

     

    • JKambli's avatar
      JKambli
      Staff
      9 years ago

      I cannot reproduce this issue on 1.7.0 version, make sure you edit the JDBC connection for other environment. I am not sure if I understand the exact issue, can you provide screenshots?