JDBC Connection String for Oracle Thin with Service Fails
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
JDBC Connection String for Oracle Thin with Service Fails
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
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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. ⬇️⬇️⬇️
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Regards,
Rao.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
