Forum Discussion
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
- nmrao9 years agoChampion Level 3Looks something trivial.
See here http://stackoverflow.com/questions/4832056/java-jdbc-how-to-connect-to-oracle-using-service-name-instead-of-sid- dd19849 years agoOccasional Contributor
Hi Rao,
I am also facing the same issue and when using the String suggested in stack overflow it's working fine but still when try to configure the Db connection it says SID is mandatory field.
What input should i give in SID field.
- abbas9 years agoOccasional Contributor
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
Related Content
- 5 years ago
- 8 years ago
Recent Discussions
- 5 days ago