Forum Discussion

pricedgp's avatar
pricedgp
Contributor
11 years ago

JDBC Returns Wrong Number of Rows

I'm using SoapUI Pro 5.1.2 (hope this is the right board!), and have a JDBC step that runs a query. This query returns only one row when run from SoapUI, but it runs two rows when run from a tool out...
pricedgp's avatar
pricedgp
Contributor
11 years ago

Update -- I just rewrote the query to select specific fields instead of doing a "select *" and it's now returning both rows as expected. 

 

Note that this query joins 5 different tables, and so I'm wondering if there's a limit on the number of fields per row that SoapUI can return. 

nmrao's avatar
nmrao
Community Hero
11 years ago
Looks the issue resolved by yourself after fine tuning the query.
Regarding the other query, I believe there should not be any limit on the number of fields per row in soapui as per my understanding.