IP
Occasional Contributor
Joined 16 years ago
User Profile
User Widgets
Contributions
Re: [RESOLVEDD]Using variables for insertion values via DataSink
Hi, Thanks for the reply. Indeed it helped by using the statement: insert into test(naam) values ("${DataSource#surname}") (so, using the double marks '.."..' instead of the single mark '..'..' ). No error occurs anymore and the value of the recent surname-value is inserted. Thanks very much. I'll continue exploring your program ;-) kind regards1.5KViews0likes0CommentsRe: [RESOLVEDD]Using variables for insertion values via DataSink
Hi, Sorry for the missing sql-query. The working sql-query (fixed value) is: insert into test(naam) values ('1') The not-working sql-query (variable) insert into test(naam) values (${DataSource#surname}) The error I get with the last query is: "java.lang.Exception: SQL problem occured" Kind regards1.5KViews0likes0Comments[RESOLVEDD]Using variables for insertion values via DataSink
Newbie Hi, I have made a testcase which works fine. However I'm trying to store the results from the webrequest in a mysql-database which gives me some trouble. The Data-connection works fine for retrieving data from the mysql-database. However (and here is the problem) I cannot seem to store the results from the webrequest into the database. Storing fixed results in the database works fine, but I don't know how to store the (variable) webresults into the database. I am getting constant sql-error. The sql-statement with a fixed surname (for instance "McCloud") works fine and looks like: I am stock with regard to the proper syntax for storing a variable from the datasource into the table "test" I have tried to find example sql-statements but haven't found any. The variable I am trying tot store is ${DataSource#surname} Can anyone please help? Kind regards3.7KViews0likes4CommentsWebpage about Data driven Testing with soapUI Pro
Hi, I'm trying to make myself familiair with data-driven testing for which there appears to be an excellent post in the eviblogging (http://www.eviware.com/blogs/oleblog/?p=619). Unfortunately the pictures don't show and the link to the example soapUI Project file (http://www.eviware.com/blogs/oleblog/wp ... roject.xml) and the excel-file (http://www.eviware.com/blogs/eviblog/wp ... driven.xls) generate an unavailable/authorisation error. It seems I have to log in somewhere but I don't know where (?) The other pages in the blog seem to working fine! Can anybody help? Sincerely IP2.1KViews0likes2CommentsRe: [RESOLVED] WS-security functionality
L.S., From another forum I got a response. They suggested filling in the action-field with the namespace of the site (which I did) and filling in the "to-field", both of them in the WS-A tab. After filling in these two field I got rid of the error. Nevertheless, thanx for putting me on the right track. It appears difficult, in general, to find more basic requirements with regard to field-values for using SOAP (not considering the official oasis-open documents, which are quite unreadable ;-)). I also found some usable information on the http://aws.amazon.com sincerely IP2.3KViews0likes0CommentsRe: [RESOLVED] WS-security functionality
Thanks for the response. Unfortunately, enabling WS-adressing in the Test request still resulted in the same message. Also enabling "Add default wsa:Acton" gave the same result. Are there perhaps any standard actions that can be filled in other then enabling default wsa:Action? I hope you have some options? Kind regards2.3KViews0likes0Comments[RESOLVED] WS-security functionality
L.S., As a newbie I'm trying to make a request on a website with WS-security functionality by username and password. Username and password are part of the soap-header. I've checked the correctness of the username and the password. They are ok. Nevertheless the site returns in the response a soapfault namely WSE012. This code is explained as "WSE012: The input was not a valid SOAP message because the following information is missing: action.". Apparently I am not sending any action through my request although the fields are filled in the soaprequest. I've tried to find the solution to this error but did not succeed. Can anyone help? Kind regards3.5KViews0likes4Comments