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
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?
