cancel
Showing results for 
Search instead for 
Did you mean: 

Connection to an Oracle database without CID, but with Servicename

dd1984
Occasional Contributor

Re: Connection to an Oracle database without CID, but with Servicename

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
Staff

Re: Connection to an Oracle database without CID, but with Servicename

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. 



Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
dd1984
Occasional Contributor

Re: Connection to an Oracle database without CID, but with Servicename

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
Staff

Re: Connection to an Oracle database without CID, but with Servicename

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?

 



Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
abbas
Occasional Contributor

Re: Connection to an Oracle database without CID, but with Servicename

Hi there,

you have to set your DB oracle configuration in bin/ext and restart your Redy API! You don't need SID.

It works.

Cheers

Abbas

New Here?
Join us and watch the welcome video:
Top Kudoed Authors