Hello,
I have been trying to connect to an Oracle DB for some time. I have tried quite a few different drivers adding them to my bin folder and always end up with a similar error for example: Failed to initialize the connection that uses the [oracle.jdbc.driver.OracleDriver] driver.
I am running version 12.1.0.2.0 on Oracle SQL Developer
Connection works on Oracle side.
Thanks for any help!
jm1,
did you place the JAR file into bin/ext folder?
What does your error log say? There should be further information which may help.
KarelHusa
Yes! I posted a screenshot of the bin folder.
The current error I am getting is: Failed to initialize the connection that uses the [oracle.jdbc.driver.OracleDriver] driver. Connection string: [jdbc:oracle:thin:<username>/<password>@<hostname>:1521/<SID>].
I am however unsure if I have the specific Jar file in the Bin folder that I need for my specific version of Oracle SQL Developer though. Any insight would be appreciated!
jm1,
I would suggest using ojdbc11.jar from https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html.
Please ensure you have only one version of ojdbc.jar in your bin/ext to avoid conflicts; it seems that you now have both versions 8 and 11.
Give it a try, and check the ReadyAPI error log for more details if necessary.
jm1 Did you connect to the oracle server using SID from SQL Developer and did it connect? If you look at the screen short of ReadyAPI, it says SID.
Usually the SQL Developer will have options to connect using either Service Name or SID. Not sure of ReadyAPI if that has both the options.
Hope below link might help!
Hello nmrao
If I understand you correctly.
I can and have been connecting to the DB through SQL Developer through SID and not service name. However, doing the same with ReadyAPI has not yet worked for me which is my current issue. I have read though your insightful link about SID vs Service name but still am unsure where to proceed.
Thanks.
