Forum Discussion

rxp396's avatar
rxp396
New Contributor
10 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 ente...
rxp396's avatar
rxp396
New Contributor
10 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
Community Hero
10 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.