Forum Discussion

shaileshra's avatar
shaileshra
Occasional Contributor
8 years ago

How can i connect oracle SQL developer connection without entering "sid".

Please find the attached screenshot as well for reference.

 

The problem i am facing is ..while connecting Oracle sql developer I am entering service name and keeping the 'SID' field blank(which is not mandatory field in the tool).

 

But in ReadyAPI(Please find the attached screenshot) sid is a mandatory field, i can not keep it blank while connecting.

 

Hence i am getting error "Can't get the Connection for specified properties; java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection"

 

 

database
JDBC
oracle sql developer
soap UI NG
  • nmrao's avatar
    nmrao
    Champion Level 3
    8 years ago
    SQL developer has option to choose either service name or sid to connect to oracle database.

    Here you should be able to connect to the same using oracle sid. Give a try.
    • shaileshra's avatar
      shaileshra
      Occasional Contributor
      8 years ago

      Thanks,

      I was able to connect it via sid/service id.