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").
Thank you for this message, but I tried it and got the following error:
Failed to init connection for driver [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:/@:1521/SHOPTEST]
!!!
Cheers
Abbas
The error message seems to indicate that the host name is missing in the connection string. Did you delete it by accident?
Did you use Nathalie's approach or the one I suggested?
Regards,
Manne
- Oracle Host name is missing in your case.
I used the following configuration:
Driver: OracleThin/oracle.jdbc.driver.OracleDriver
Connection String template: jdbc:oracle:thin:<catalog>/<catalog>@<HOST:10.7.1.50>:<PORT:1521>/SHOPTEST
and I have contact to the named database with SQL Developer, but I get the following error:
" Failed to init connection for driver [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:/@10.7.1.50:1521/SHOPTEST] "
What I did:
1- in config Coection String template like above
2- Database Configuration -->New
Driver: OracleThin/oracle.jdbc.driver.OracleDriver
Host: 10.7.1.50
Port: 1521
3: Click Test connection ---> Result: Erorr:
" Failed to init connection for driver [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:/@10.7.1.50:1521/SHOPTEST] "
And the same problem with the following Connection String:
jdbc:oracle:thin:catalog/catalog@HOST:ractest-scan:PORT:1521/SHOPTEST
