Contributions
Data driven testing-Data source JDBC
Hi All, I am implementing data driven testing in Ready API 1.9.0 by using data source as excel and JDBC both. I want to give input(number,date)values to SQL query in JDBC data source from excel data source. Providing input value to number(${DataSource_Excel#number}) from excel data source works fine.but giving input value to date (${DataSource_Excel#date}) gives error pop up saying "DB2 SQL Error:SQLCODE=-104,SQLSTATE=42601,SQLERRMC=nbr= and;AND,DRIVER=4.12.55" Any suggestions plz?7 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.1KViews0likes2CommentsData driven testin gusing Datasource excel and JDBC both.
I am using 2 data source in my project one for excel and another one for JDBC. I use excel data source as one source of input. I pass some values in excel data source to JDBC data source to retrive data from database. I pass some values from excel as an input for POST query I get web service response. Data base shows output has mutiple rows. The problem is when I try to add assertion to service response by comapring with JDBC data source output I am unable to select specific value in a column as a column contains multiple records. Ready API is taking only the top most value of the JDBC output.7 years agoPlace ReadyAPI QuestionsReadyAPI Questions560Views0likes0CommentsData driven testing
Hi , I am trying to do data driven testing in Ready API 1.9.0 (SoapUING pro) using datasource as JDBC and database is IBM DB2.But facing issue while comparing response values withdatasource JDBC values. e.g. Response is having 3 transaction time values.When validating these 3 transaction time values with JDBC datasource transaction time values with assertion validation is happening only for 1 value and because of that assertion is getting failed.7 years agoPlace ReadyAPI QuestionsReadyAPI Questions536Views0likes0Comments