Forum Discussion

RajuK's avatar
RajuK
New Contributor
5 years ago

Anyone having luck with using JDBC driver and connect to TCPS/SSL on Oracle

I am able to connect when using TCP port , but having issues connecting to TCPS port. I have copied valid cacerts file to Java location. It fails with below expection:   SQLRecoverableException: I...
RajuK's avatar
RajuK
New Contributor
5 years ago

Thanks Richie.

 

Actually I found a work around. 

 

We could use the below format for JDBC url to connect to Oracle DB on TCPS and use generated Java cacerts.

JDBCURL:

USER/PASS_VALUE@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=hostname)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=servicename)))

 

ReadyApi did not provide a way to configure JDBC url with this format. So I have updated the project.xml file to reflect the above format and it works now.

 

  • richie's avatar
    richie
    Community Hero
    5 years ago
    Hey RajuK,

    Great that you sorted it!

    Just to be clear, ReadyAPI! does support what you need. That string youve included below that starts JDBCURL is actually the string that gets added to your tnsnames.ora file when the db is created.

    You just needed to edit and update the default oracle JDBC connection string (within the ReadyAPI! JDBC Preferences) to add in the required parameters defined within that tnsnames value youve included below.

    Nice one,

    Rich
    • RajuK's avatar
      RajuK
      New Contributor
      5 years ago

      Yes,

      Except I could not do "edit within the ReadyAPI! JDBC Preferences", hence I updated the xml file using xml editor.

      • richie's avatar
        richie
        Community Hero
        5 years ago
        RajuK,

        Really? That's weird...always been able to edit them before, otherwise you wouldnt be able to add in any further db connections that arent included within the default listing.

        What version of ReadyAPI! are you running?

        Could you provide a screenshot of the jdbc preferences after attempting to select a row in the form window? Might be able to work out whats wrong, cos you should definitely be able to edit those settings!

        Ta

        Rich