Forum Discussion
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
- abbas8 years agoOccasional Contributor
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] "
- abbas8 years agoOccasional Contributor
And the same problem with the following Connection String:
jdbc:oracle:thin:catalog/catalog@HOST:ractest-scan:PORT:1521/SHOPTEST
- nmrao8 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
Related Content
- 4 years agoPUM-Prodat-SQL
- 7 years agoGaleG