Forum Discussion
14 years ago
I have not found a way to do this directly in SoapUI, but I found the following workaround:
Setup the JDBC connection in SoapUI
Save the project XML, then close SoapUI
Open your project XML file in an editor
Search for the keyword "oracle"
Change the URLs that look like
USER/PASS@SERVER:PORT:INSTANCE
to be formatted
USER/PASS@//SERVER:PORT//INSTANCE
Then save the XML and reload it into SoapUI and it will connect. However, once you do this you CANNOT edit the JDBC URL in SoapUI any longer, as it will corrupt the string and you will need to edit the XML file again to restore the values.
Hope that this helps!
(Note: It would be GREAT if a check box could be added to the connection string syntax builder for Oracle RAC or something like that to make this fairly trivial conversion supported by the application)
Setup the JDBC connection in SoapUI
Save the project XML, then close SoapUI
Open your project XML file in an editor
Search for the keyword "oracle"
Change the URLs that look like
USER/PASS@SERVER:PORT:INSTANCE
to be formatted
USER/PASS@//SERVER:PORT//INSTANCE
Then save the XML and reload it into SoapUI and it will connect. However, once you do this you CANNOT edit the JDBC URL in SoapUI any longer, as it will corrupt the string and you will need to edit the XML file again to restore the values.
Hope that this helps!
(Note: It would be GREAT if a check box could be added to the connection string syntax builder for Oracle RAC or something like that to make this fairly trivial conversion supported by the application)