cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle database Connection Configuration issue

New Contributor

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 3
Community Hero

Re: Oracle database Connection Configuration issue

It is not mandatory to use service name, you can still use sid to connect.


Regards,
Rao.
New Contributor

Re: Oracle database Connection Configuration issue

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

 

Community Hero

Re: Oracle database Connection Configuration issue

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.


Regards,
Rao.
New Here?
Join us and watch the welcome video:
SeptemberNews
Join the exciting event
SeptemberHubBub
Top Kudoed Authors
Join the September Hub-bub to show off, learn and win