Forum Discussion

Chick-fil-A__In's avatar
Chick-fil-A__In
13 years ago

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

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

Sowmya13's avatar
Sowmya13
Occasional Visitor
6 years ago

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?