Forum Discussion

vineethwip's avatar
vineethwip
New Contributor
7 years ago

Error connecting to oracle database in soap ui jdbc request

Hi

 

Can anyone help me with jdbc request for establishing connection with oracle database

I am using below

 

Driver oracle.jdbc.driver.OracleDriver

Connection string jdbc:Oracle:thin:@//gbl10263.systems.uk.hsbc:2001/ CAAERTL07.systems.uk.hsbc), "WEBPROXY", "WEBPROXY.123"

 

I am getting  error 'Failed to init connection for driver'

 

This works fine in sql developer

 

please let me know if there's any issue with syntax for connection string

 

4 Replies

Sort By
  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    SmartBear Alumni (Retired)
    7 years ago

    Hi,

     

    Thank you for your post. To be able to work with the Oracle database, you need to place the required jar file (ojdbc6.jar or ojdbc14.jar) to the <ReadyAPI_Install>\bin\ext folder. 

     

    If you use Oracle 10 you will need the ojdbc12.jar file,

    if you use Oracle 11g or 12c release, you need the ojdbc6.jar file.

     

    The connection string template is the following:

    jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1521>:<SID>
    • edweerdt's avatar
      edweerdt
      Contributor
      7 years ago

      After updating to 2.3.0 my Oracle connections stopped working. Maybe this is also the issue for you?

      • Fionna's avatar
        Fionna
        New Contributor
        7 years ago

        I found that after updating to 2.3.0 I had to have ojdbc6-11.jar in the bin\ext directory for the connections to work

Recent Discussions