Forum Discussion

rxp396's avatar
rxp396
New Contributor
9 years ago

Oracle database Connection Configuration issue

I need to connect to Oracle database to run sql queries from SOAPUI Pro within Ready!API. 

I selected  oracle Thin/oracle.jdbc.driver.oracleDriver in Database Configuration.

However, I have to enter service-name instead of SID, but I donot seCapture.PNGe that option in dbase configuration settings. Please help

3 Replies

Sort By
  • nmrao's avatar
    nmrao
    Champion Level 3
    9 years ago
    It is not mandatory to use service name, you can still use sid to connect.
    • rxp396's avatar
      rxp396
      New Contributor
      9 years ago

      Hi, Thanks for your reply.

      In our database connection properties, we no longer use SID, we specify service-name.

      That is how we connect even using SQL Developer.

      I have to use service-name to connect instead of SID to connect to database.

      I tried putting service-name value in SID field in connection details of  SOAPUI Pro, but connection failed.

       

      Please advice. Thank You.,

       

      Rama Pavoor

       

      • nmrao's avatar
        nmrao
        Champion Level 3
        9 years ago
        I do not think, there is really an option. Not aware of any such constraint that you not use. You can find sid by querying database if that is something sid is not known.