Forum Discussion

Chick-fil-A__In's avatar
Chick-fil-A__In
13 years ago

JDBC Connection String for Oracle Thin with Service Fails

What is the appropriate format to make a JDBC Connection via Oracle Thin Client Connection which uses a Service Name, not a SID, and also needs a password? This works format works in SQL Developer ...
SmartBear_Suppo's avatar
SmartBear_Suppo
SmartBear Alumni (Retired)
13 years ago
Hello,

did you try

jdbc:oracle:thin:USERNAME/PASSWORD@HOST:PORT:SID

Regards,
Vladimir
SmartBear Software
  • RestFreak's avatar
    RestFreak
    New Contributor
    8 years ago

    Hi Valdimir, 

     

    I have tried using connection string as you mentioned

    jdbc:oracle:thin:<USERNAME/PASSWORD@HOST>:<PORT>:<SID>

    I am getting 

    "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" error. 

    I don't have SID  to establish connection using SoapUI pro. 

    As mentioned in thread question, I am trying to connect using Service name.

     

    Can you please let me know How can I establish Oracle Thin JDBC connection using Service name in SOAPUI Pro?

     

    • nmrao's avatar
      nmrao
      Champion Level 3
      8 years ago
      May be you check with other clients such as Oracle Developer or Toad or command line sqlplus and see if that works.
      • RestFreak's avatar
        RestFreak
        New Contributor
        8 years ago

        I am able to establish connection using oracle developer,

        But when I try to establish same connection using SOAPUI Pro it is asking for SID and getting error mentioned above. 

        Can you please help me how we establish Oracle thin DB connection using SopaUI pro with Service Name?

         

        Thanks 

        RestFreak