Forum Discussion

arvndv's avatar
arvndv
Occasional Contributor
5 years ago
Solved

ReadyAPI 2.3 Oracle JDBC Fails to Initiate in Data Source and/or JDBC Request

Getting below error while trying to connect to database from SoapUI Pro.  Complete Error Descr:-  "Failed to initialize the connection that uses the [oracle.jdbc.driver.OracleDriver] driver. Conn...
  • arvndv's avatar
    arvndv
    5 years ago

    richie 

    Thank you for your sincere and detailed responses. Finally, I am able to resolve the problem. 

    Seems ReadyAPI installs both 32-bit and 64-bit versions in the machine, I didn't know that I am acutally using the 32-bit version. Apparently the folder is different for the 32-bit version. It worked after I copied the files there.

    :)

arvndv's avatar
arvndv
Occasional Contributor

Hi richie

Thanks for your inputs. I tried, copied the files to bin/ext Restared app and then the machine. Still no luck.

Still giving me the same error.

richie's avatar
richie
Community Hero
5 years ago
Hi arvndv,

Ok. I have a couple more suggestions.

I double checked, you definitely had the .jar files in the wrong directory....i do have .jar files in my /lib directory, but the db connection driver .jars go in the bin/ext directory.

You say you can connect to the db via sql developer. Have you got oracle client installed at all? Cos if you have it'll use the tnsnames.ora file by default despite attempting to setup connection via the thin driver....or at least that was the way it worked about 5 years ago (last time i was using oracle). Setup connection with db visualiser...that definitely only supports thin client oracle driver.

Can you investigate the connection string? I had to setup a new connection for a MIMER RDBMS and the connection string i had to use deviated very slightly from the published documentation...this is a longshot...but still worth checking.

The failed to initialise leads me to believe its either the drivers (which youve confirmed is in the correct directory now, so shouldnt be a problem) or the connection string. There was a recent post about 2 weeks ago cos the author couldnt connect once the oracle had been setup clustered using service name, rather than the old SID....have a think about this, there might be a problem with the service name parameter in your connection string.


You mention the db connection works on soapui v5.3.0 is this on the same machine as readyapi!? Or on a separate machine? If its on a separate machine, best way to check if it is readyapi! or your settings is install soapui free on the same machine you have readyapi!
Setup the db connection that you have configured on the machine with soapui 5.3.0 in the latest free soapui instance (same machine as readyapi!). Reproduce the config from the other soapui machine in the newly installed soapui. Can you connect?
Finally, you mentiom readyapi! v2.3.0. Try upgrading and reconnecting....id upgrade sequentially and id only try this after all other avenues were attempted....especially if theres a reason you havent already upgraded from v2.3.0

Ok...thats the ideas from me,

Cheers,

Richie
  • arvndv's avatar
    arvndv
    Occasional Contributor
    5 years ago

    You say you can connect to the db via sql developer. Have you got oracle client installed at all?
    Ans: Yes

     if you have it'll use the tnsnames.ora file by default despite attempting to setup connection via the thin driver
    Ans: Sorry, don't get this part. Should I be using a different conn string format then?

    Setup connection with db visualiser -
    Ans: Are you referring to the "configure" window in SoapUI? If this is a new software, sorry, I am not allowed to do that without proper business justification.

    You mention the db connection works on soapui v5.3.0 is this on the same machine as readyapi!? Or on a separate machine?
    Ans: Same Machine. Using Conn String format -
    jdbc:oracle:thin:<USER>/<PASSWORD>@//<HOST:127.0.0.1>:<PORT:1521>/<SID>

    Try upgrading and reconnecting
    Ans: Sorry cant do upgrade now.

    • richie's avatar
      richie
      Community Hero
      5 years ago

      Hi arvndv 

       

      The reason why I asked if you have Oracle client installed is because Oracle client software uses a file called tnsnames.ora to create and configure database connections.  Quite often if you install some software to interrogate the oracle database (like SQLDeveloper etc.), the software will use the db connection defined in the tnsnames.ora file rather than use Oracle's thin driver (the JDBC connection string option) and you'll think your using the JDBC connection string - but in fact the software uses the tnsnames.ora file.

      Admittedly this was about 5 years ago - perhaps things have changed since I last used Oracle.

       

      DBVisualiser is a DB interrogation tool that cannot use Oracle's tnsnames.ora file (or at least it couldn't 5 years ago) - if you could connect to the same db via DBVisualiser it would confirm the problem was with ReadyAPI! config.

       

      Unfortunately I didn't read your original post properly.  You already have a soapui instance on the same machine as your readyapi! machine and you can connect to the database fine with soapui.

       

      I did come across this about 3 months ago with SQLServer - I could connect to the DB using SoapUI (windows authentication) fine - but ReadyAPI! couldn't connect (using the windows authentication) - despite using the correct drivers etc.

      I had to change the authentication to SQLAuthentication instead before it connected but that doesn't solve your problem.

       

      I've noticed when setting up db connections for certain databases in soapui - I've had to add in a new connection string as the default connection string doesn't always do what is necessary.  i.e. your database instance might need some extra parameters that aren't represented in the default connection string.

       

      have a look at the following link

       

      cheers,

       

      richie

      • arvndv's avatar
        arvndv
        Occasional Contributor
        5 years ago

        richie 

        Thank you for your sincere and detailed responses. Finally, I am able to resolve the problem. 

        Seems ReadyAPI installs both 32-bit and 64-bit versions in the machine, I didn't know that I am acutally using the 32-bit version. Apparently the folder is different for the 32-bit version. It worked after I copied the files there.

        :)