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
Forum Discussion
Hello Abbas,
The connection string templates in R!API are customizable. You can edit them on the "JDBC drivers" tab in preferences.
In your case, I guess, you need to replace
jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1521>:<SID>
with
jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1521>/SERVICE
where instead of "SERVICE" you need to provide your real service name (e.g. "orcl").
Hi,
thank you TanyaGorbunova !!!!! 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,
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.
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!!
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?
