Contributions
- 4 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.4KViews0likes0Comments
ReadyAPI (SoapUI Pro) and SoapUI (free) on same PC
I have ReadyAPI (SoapUI Pro) on my PC. Some members of my team have SoapUI (free version) on theirs. Oftentimes, I need to switch to SoapUI free to mimic their environment. To accomplish this, I setup a workspace for ReadyAPI (readyapi_workspace) and another, separate workspace for SoapUI (soapui_workspace). However, whenever I boot either program, it uses the settings of the other. i.e., if I: 1) open SoapUI, 2) switch workspace to soapui_workspace, 3) open ReadyAPI -- the workspace in ReadyAPI will be the soapui_workspace. Then if I 4) switch ReadyAPI to readyapi_workspace the next time I close/open SoapUI, the workspace will be the readyapi_workspace in SoapUI. Whatever you do in one affects the other. The entire purpose of workspaces in these Eclipse environments is to avoid this. Is there a way to make the two programs completely independent and ignorant of each other so that changing one does not affect the other, specifically the default workspace?Solved4 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.5KViews0likes3CommentsRe: How to connect to an Oracle Thin DB which is identified by 'Service Name' instead of SID
Further digging, I found this article: https://community.smartbear.com/t5/SoapUI-Pro/Connection-to-an-Oracle-database-without-CID-but-with/td-p/121201 The solution is to manually edit either the driver or the connection string. See the accepted answer in the linked article. I was able to achieve it.5 years agoPlace ReadyAPI QuestionsReadyAPI Questions4.8KViews1like2CommentsRe: How to connect to an Oracle Thin DB which is identified by 'Service Name' instead of SID
To be clearer: the change that needs to be made is that ReadyAPI needs to allow connection strings to be in the following format: jdbc:oracle:thin:user/PASS_VALUE@xyz.int.com:1521/DBSCHEMA currently, it only allows this (as far as I can tell): jdbc:oracle:thin:user/PASS_VALUE@xyz.int.com:1521:DBSCHEMA The difference: the Service Name takes a / between it and the port, not a : Another related SO Q&A: https://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript5 years agoPlace ReadyAPI QuestionsReadyAPI Questions5.7KViews0likes3CommentsRe: How to connect to an Oracle Thin DB which is identified by 'Service Name' instead of SID
My intermediate-level knowledge of JDBC leads me to the conclusion that, unless Ready API specifically has a capability to add "Service Name" instead of SID, that this will never be possible. This StackOverflow question/answer demonstrates that the JDBC connection string will need to be of a different structure if one expects to use Service Name in lieu of SID: https://stackoverflow.com/questions/4832056/java-jdbc-how-to-connect-to-oracle-using-service-name-instead-of-sid Many database clients have capability for Service Name / SID switching. Here are some examples: SQL Developer DBeaver So I think the Ready API developers need to consider adding the option of Service Name-based JDBC functionality.5 years agoPlace ReadyAPI QuestionsReadyAPI Questions5.7KViews0likes4Comments