Forum Discussion
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
Yes,
Except I could not do "edit within the ReadyAPI! JDBC Preferences", hence I updated the xml file using xml editor.
- richie4 years agoCommunity HeroRajuK,
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- RajuK4 years agoNew Contributor
SmartBear provided a solution which I am going to try.
And like you said there is a way to update the JDBC .
I am going to try today. Thanks.
Solution from Smart Bear:
-Doracle.net.tns_admin={file location} in the {ReadyAPI install}\bin\ReadyAPI.vmoptions
After this, you can add a new connection string template or modify an existing one in Preferences > JDBC Drivers:
jdbc:oracle:thin:<USER>/<PASSWORD>@<TNSName>
In this case, you will need to use the manual JDBC Request test step configuration. Choose None for the Connection and click Configure. Fill in your credentials in the Database configuration dialog and specify the TNSName in the Connection string field.- sonya_m4 years agoSmartBear Alumni (Retired)
Thank you for sharing this! Was this a success?