pedro
Occasional Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Groovy - Cassandra Connection using core datastax drivers not JDBC
I have tried to use JDBC connection string but I am having the following error message while trying to establish the connection to cassandra but as I have a native port cassandra set up Can anyone help on USING core datastax drivers INSTEAD JDBC connection? Code (JDBC not working with my cassandra setup): import java.sql.DriverManager; import java.sql.SQLFeatureNotSupportedException; import java.sql.Statement; import javax.sql.DataSource; import org.apache.cassandra.cql.jdbc.*; com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("org.apache.cassandra.cql.jdbc.CassandraDriver"); def con = DriverManager.getConnection("jdbc:cassandra://IP_ADDRESS:9042/activation"); //keyspace has to be in lowercase def stmt = con.createStatement(); //add data def qry = "SELECT * fROM activation WHERE activation_id = '001010126' and activation_N_id ='01';" def rs = stmt.executeUpdate(qry) ERRROR MESSAGE java.sql.SQLExeption: Incorrect URL: jdbc:cassandra... (Image Attached)2.7KViews0likes3CommentsRe: Cassandra Connection with Groovy Script In SoapUI
I have tried to use the code provided but I am having the following error message while trying to stablish the connection to cassandra: import java.sql.DriverManager; import java.sql.SQLFeatureNotSupportedException; import java.sql.Statement; import javax.sql.DataSource; import org.apache.cassandra.cql.jdbc.*; com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("org.apache.cassandra.cql.jdbc.CassandraDriver"); def con = DriverManager.getConnection("jdbc:cassandra://IP_ADDRESS:9042/activation"); //keyspace has to be in lowercase def stmt = con.createStatement(); //add data def qry = "SELECT * fROM activation WHERE activation_id = '001010126' and activation_N_id ='01';" def rs = stmt.executeUpdate(qry) ERRROR MESSAGE java.sql.SQLExeption: Incorrect URL: jdbc:cassandra... (Image Attached) I got information from my DevTeam that this is a cassandra database uses a NATIVE PORT : 9042. Does anybody have any more information about what might be the reason I am getting the error above? Thanks for your help!3.1KViews0likes1CommentRe: JsonPath RegEx Match
I found this post where version 1.9 has a bug and it does not save the RegEx. https://community.smartbear.com/t5/SoapUI-NG/Bug-Cannot-save-a-regex-statement-for-JSONPath-RegEx-Match/m-p/139894#M31500 please read the latest post on that thread. Regards4.8KViews1like0CommentsHow to Assert Regex Rest response with groovy script?
Hello everyone, I am struggling with a validation I need to make because in SoapUI NG 1.9 does not work the JSONPath RegEx Match Assertion(image attached) Can anyone help on how to perform this assertion I need to use to validate a RegEx json node? I am trying to validate the following hour format in a node at REST response: YYYY-MM-DDThh:mm:ss.sTZD (e.g. 1997-07-16T19:20:30.45+01:00) Please can anyone help with this? Thanks in advance. :D PedroSolvedHow to Assert values sent in Request Body at Rest response?
Hi I am trying to make an assertion of the request body I am sending in a PUT method on the response of a GET method in another step. Request body sent in PUT method: { "storeId" : "0010", "registerNumber" : "0012" } Json response in GET method: { "PackageId": "188800120412201723609318", "storeId" : "0010", "registerNumber" : "0012" "lineId": "01" "createdTimestamp": "04-19-2017 3:22 PM Wed UTC" } How can I map each node on the JSON (storeId , registerNumber ) sent in the request body at the JSON response to the same Thanks! SOAPUI NG 1.9 Kind regards, Pedro2.8KViews0likes1Comment