Database testing using soap ui/ready api ?
My REST web service populate db records as output. I can connect to db server using jdbc from soap ui. How can I compare data populated in REST request and JDBC request ? Below are few points to consider: 1. The column names in REST request and JDBC request are different but data is same. 2. The order of the records also differs. So how can I compare data output of REST service and JDBC request ? Is there any way I modify the output order in both REST service and JDBC request ?so that I canmake them to display in same order and compare the data. Also looking to automate the process for multiple requests. Please guide me with a right solution Hope I clearly explained the challenge. Looking for a right solution. Thanks, Ravi
Cassandra Connection with Groovy Script In SoapUI
Dear Community, thanks for the time. I am trying to access a remote Cassandra DB in order to complete my assertions. I see that the Server is running: Cassandra V 3.0.8.1293 Driver Type: Cassandra CQL Datastax Java Driver for Apache Cassandra - Core [3.0.5] So, I am trying with the following code to access the DB import com.datastax.driver.core.* Cluster cluster = null; try { cluster = Cluster.builder().addContactPoint("x.x.x.x").withCredentials("xxxxxxx", "xxxxxx").withPort(9042).build() Session session = cluster.connect(); ResultSet rs = session.execute("select * from TABLE"); Row row = rs.one(); } finally { if (cluster != null) cluster.close(); } when I use the cassandra-driver-core-2.0.1.jar I am getting the error : ERROR:com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /x.x.x.x(null)) Read the documentation and a lot of posts here and on other blogs and I saw that there may be an incompatibility with the driver version so I tried to upgrade the driver to many versions (cassandra-driver-core-2.5,cassandra-driver-core-3,cassandra-driver-core-3.2), but on that I am getting the following: ERROR:java.lang.ExceptionInInitializerError Have also tried to connect using JDBC, but to no avail. using the configuration proposed at this thread https://community.smartbear.com/t5/SoapUI-NG/Apache-Cassandra-CQL-jdbc-connection/td-p/40050 Actually I am running out of ideas. Can anyone propose or point to some direction on how to actually achieve this, either by pointing me to some tutorial or any idea. Thank you very much
How can i connect oracle SQL developer connection without entering "sid".
Please find the attached screenshot as well for reference. The problem i am facing is ..while connecting Oracle sqldeveloper I am entering service name and keeping the 'SID' field blank(which is not mandatory field in the tool). But in ReadyAPI(Please find the attached screenshot) sid is a mandatory field, i can not keep it blank while connecting. Hence i am getting error "Can't get the Connection for specified properties; java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection"
Cannot Connect to Oracle RDB Database
I'm trying to connect to an Oracle RDB Database which is not one of the listed databases. I have the driver for it and put it in the bin/ext folder. After trying to fill out the information in JDBC Drivers PropertiesI tried a number of ways to connect to it but with no luck. I'm looking for guidance as this is the first time I've tried to connect to a database type that wasn't listed as one of the defaults. Is there a specific way I need to enter the Driver name on the JDBC Drivers Properties page? I tried just using the name, the file name, the exact file path, but none worked. Currently this is the error I'm getting no matter what I try. Any help would be appreciated.
