cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Connection String for Oracle Thin with Service Fails

Highlighted
Not applicable

JDBC Connection String for Oracle Thin with Service Fails

What is the appropriate format to make a JDBC Connection via Oracle Thin Client Connection which uses a Service Name, not a SID, and also needs a password?

This works format works in SQL Developer but not in SOAPUI Pro JDBC Connection or Groovy.
jdbc:oracle:thin:<USER>@<HOST:127.0.0.1>:<PORT:1521>/<SID>

Where SID is actually the Service name with a String.String format.

Please help.

Regards
5 REPLIES 5
Highlighted

Re: JDBC Connection String for Oracle Thin with Service Fail

Hello,

did you try

jdbc:oracle:thin:USERNAME/PASSWORD@HOST:PORT:SID

Regards,
Vladimir
SmartBear Software

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️Please mark my answer as a solution if it was helpful
Highlighted
New Contributor

Re: JDBC Connection String for Oracle Thin with Service Fail

Hi Valdimir, 

 

I have tried using connection string as you mentioned

jdbc:oracle:thin:<USERNAME/PASSWORD@HOST>:<PORT>:<SID>

I am getting 

"ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" error. 

I don't have SID  to establish connection using SoapUI pro. 

As mentioned in thread question, I am trying to connect using Service name.

 

Can you please let me know How can I establish Oracle Thin JDBC connection using Service name in SOAPUI Pro?

 

Highlighted
Community Hero

Re: JDBC Connection String for Oracle Thin with Service Fail

May be you check with other clients such as Oracle Developer or Toad or command line sqlplus and see if that works.


Regards,
Rao.
Highlighted
New Contributor

Re: JDBC Connection String for Oracle Thin with Service Fail

I am able to establish connection using oracle developer,

But when I try to establish same connection using SOAPUI Pro it is asking for SID and getting error mentioned above. 

Can you please help me how we establish Oracle thin DB connection using SopaUI pro with Service Name?

 

Thanks 

RestFreak

Occasional Visitor

Re: JDBC Connection String for Oracle Thin with Service Fail

Is there any way to connect to Oracle DB with Service name ? I am also facing the same error while connecting with service Name . Is Sid the only way for making the connection?

New Here?
Join us and watch the welcome video:
Announcements
Script Wanted
The new challenge is here!

Create a script to сhange an XPath Match assertion to a JSONPath Match assertion for the TechCorner tag!


Scripts created in July:
- A script to generate an email when an assertion fails
- A script to change the request body before sending it to the server
Top Kudoed Authors