Contributions
Re: jdbc error getting response for myTeststep; null
I have solved my problem. Because of trying difference jdbc-drivers, there was a wrong jar-file version. Using my java-code in a groovy step, it has returned a Class-not-found-exception. Then I checked the jars and found a wrong version. The jdbc-driver expected a newer version of the cassandra-driver-core. On trying an earlier jdbc-driver, there was an older version in the lib directory. Why is this exception not thrown in the normal JDBC-Request-Step?5 years agoPlace ReadyAPI QuestionsReadyAPI Questions2.1KViews1like0CommentsRe: jdbc error getting response for myTeststep; null
Oh, I missed to show my sql-query in Ready-API, but it is the same as in the java code. import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Test { public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException { String url = "jdbc:cassandra://localhost:9042/mykeyspace?user=myusername&password=mypassword"; DriverManager.getDriver(url); Connection con = DriverManager.getConnection(url); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select * from mykeyspace.mytable limit 5;"); while (rs.next()) System.out.println(rs.getString(1)); rs.close(); stmt.close(); con.close(); } }5 years agoPlace ReadyAPI QuestionsReadyAPI Questions2.1KViews0likes1CommentRe: jdbc error getting response for myTeststep; null
I've wrote a small simple java program to test the connection string and the the sql-query. Both worked fine with my choosen jdbc-driver. If something was wrong in my java programm, i get a helpful exception with stacktrace from the driver. In Ready-API I get always the same error "null", don't matter what's wrong. So heres is a sample screenshot of my Ready-API JDBC-Teststep, with the error:5 years agoPlace ReadyAPI QuestionsReadyAPI Questions2.1KViews0likes3Commentsjdbc error getting response for myTeststep; null
I've tried to connect to a Cassandra-DB with the following driver: com.dbschema.CassandraJdbcDriver https://github.com/DataGrip/cassandra-jdbc-driver After configured the JDBC-Request Step and running them, I get two messages in the ReadyAPI Log and no StackTrace in the error log: The JDBC driver [com.dbschema.CassandraJdbcDriver] is already registered. Thu Mar 19 17:40:37 CET 2020: INFO: Error getting response for [myTestStep]; null By passing a wrong Connection-String to the driver, a driver-exception occurs. So I think I use the correct Connection-String. jdbc:cassandra://localhost:9042/mykeyspace?user=myusername&password=PASS_VALUESolved5 years agoPlace ReadyAPI QuestionsReadyAPI Questions2.2KViews0likes6CommentsAssertion on Http-Status 204 with Content-Length: 0
I've noticed that an assertion on "Valid HTTP Status Codes" with an HTTP Status Code 204 with Content-Length: 0 results in an error ("Wrong server response: responses with the 204 status code must not contain the "Content-Length" header.") I have seen that other users had the same problem, unfortunately, the problem seems still exists in Ready API 1.9.0. Regarding on following posts: https://community.smartbear.com/t5/SoapUI-NG/Issue-with-Raw-response-in-readyAPI-1-9-0-when-response-is-blank/m-p/131877/ https://community.smartbear.com/t5/SoapUI-NG/Http-Status-Code-204-not-recognized-as-Valid-or-Invalid-Code/m-p/21954/ https://community.smartbear.com/t5/SoapUI-NG/Assertion-fail-for-valid-HTTP-code-204/m-p/130267/ Is there already a solution without Groovy or using an older version?Solved8 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.8KViews0likes1Comment