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 but not in SOAPUI Pro JDBC Connection or Groovy.
jdbc:oracle:thin:<USER>@<HOST:127.0.0.1>:<PORT:1521>/<SID>

Where SID is actually the Service name with a String.String format.

Please help.

Regards
  • 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.