Forum Discussion

Raju_Vusirikala's avatar
Raju_Vusirikala
Contributor
15 years ago

trouble connecting oracle RAC from soap UI pro 3.5

Hi I am trying to connect Oracle RAC from soapUI, but I am getting below error message

used driver: oracle.jdbc.driver.OracleDriver
connection: jdbc:oracle:thin:username/password@host:por:sid

Can't get the Connection for specified properties; java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I m using the service name value for SID as I don't have a SID for my DB.Is this causing the problem? or any other driver should be used to connect clusters of DB?
  • WlidfireTech's avatar
    WlidfireTech
    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)