alejandrovargas
Occasional Contributor
Joined 10 years ago
User Profile
User Widgets
Contributions
Re: Problem to connect SoapUi with Cassandra DB.
Hi, thanks for your answer. I read the article and I downloal again the jars. I continue with problem to connect, After searching more in Internet, I found this good blog with the string connection: http://abhishekasthana.com/accessing-cassendra-soapui/ Case 1: Connection String: jdbc:cassandra://username/password@servername:port/keyspacename_smallcase (I was missing // before the user name) I get this error: Error: Can't get the Connection for specified properties; java.sql.SQLNonTransientConnectionException: Connection url may only include host, port, and keyspace, consistency and version option, e.g., jdbc:cassandra://localhost:9170/Keyspace1?version=3.0.0&consistency=ONE2.4KViews0likes2CommentsProblem to connect SoapUi with Cassandra DB.
Hi, I am trying to connect to Cassandra DB using JDBC step. The database is in a server, so I need to authentication to login (of course I have the user and password). I tried the connection using Datastax DevCenter and it works. The problem is with the connection string (I think), I haved tried two options: First option Driver: org.apache.cassandra.cql.jdbc.CassandraDriver Connection String: jdbc:cassandra://ip-address:port/tracking_system error: Can't get the Connection for specified properties; java.sql.SQLSyntaxErrorException: InvalidRequestException(why:You have not logged in) It was an expected error because I am not using user and password. Second option Driver: org.apache.cassandra.cql.jdbc.CassandraDriver Connection String: jdbc:cassandra:user/password@ip-address:port/tracking_system error: Can't get the Connection for specified properties; java.sql.SQLNonTransientConnectionException: Connection url must specify a host, e.g., jdbc:cassandra://localhost:9170/Keyspace1 ¿Somebody knows how is the Connection string using user and password? Thanks for your help in advance.2.4KViews1like4CommentsRe: Xquery assertion - search a variable inside a node
Sorry to answer late, I took some days for the eastern week. I need an output similar to the input is right, I need to confirm values that comes from the database that are chaning. I tried to use XQuery and not Xpath to use less amount of assertions. I do not if this is possible with XQuery, or I should use Xpath.967Views0likes0CommentsXquery assertion - search a variable inside a node
Hi, Using XQuery assertion we need to print the text of a variable that is inisde a node. In the file attached appears the value that I need, and the wrong answer with extra information that we do not need. XQuery Expression <Result> { for $x in //baggageEstimationFees/baggageConditions/selectableBaggageDescriptor return <element> <pieces>{$x/baggageDescriptor[@pieces]}</pieces> <price>{$x/price/text()}</price> </element> } </Result> Our result expected: <Result> <element> <baggageDescriptor pieces="0"/> </pieces> <price>0.00</price> </element> <element> <pieces> <baggageDescriptor pieces="1"/></pieces> <price>37.50</price> </element> </Result> Or: <Result> <element> <pieces>0</pieces> <price>0.00</price> </element> <element> <pieces> <pieces>1</pieces> <price>37.50</price> </element> </Result>1KViews0likes2CommentsRe: How to use +days option to avoid an specific day.
Hi, Thanks for your answer. Yesterday we could find the solution for my problem, I will explain because it could be useful for other people: Command: ${=import java.text.SimpleDateFormat; new SimpleDateFormat('yyyy-MM-dd').format(new Date() + 31*5 + (int)(Math.random()*10))} This exemple uses current day + 31*5 + random value between 0 and 9 In the file attached you can see where the code were pasted. This window was opened with double-click in the project.1.7KViews2likes1CommentHow to use +days option to avoid an specific day.
Hi all, I have some tests that I need to execute almost everyday, tests always make a search 3 days in the future. The problem is that I always have to change the date manually to 3 days in advance, SOAPUI has the option to use +3days or something similar to avoid change the date everytime I used. In Behat I could coonfigure with +3days, but not in SOUPUI. Thanks for your help.Solved1.7KViews0likes4Comments