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 outside SoapUI. I was expecting two rows.

 

Is there some limitation in SoapUI, some caching (I've already restarted), or anything else that might explain this behavior?

 

 

  • 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
      Icon for Champion Level 2 rankChampion Level 2
      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.