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
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] "