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

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.