Forum Discussion

wellaflex15's avatar
wellaflex15
New Contributor
4 years ago

ReadyAPI 3.6.0 DataSource JDBC - data won't show in the properties

When I try to use JDBC as the DataSource in a DataSource Loop the data comes out as blank in the properties I specifiy.

If I use the query builder I get it to work inside the builder but as soon as I'm back to the DataSource and try it I only get blank answers. I can see in the logs that the right number of rows are retrieved but no data is stored in the properties. 

Does anyone have the same problem? 

Data-Driven Testing
  • nmrao's avatar
    nmrao
    4 years ago
    Nice and valid use case for data source.

    If you have show stopper, then following can be tried.
    Get the data from jdbc step and write the rows into a file(use a format supported by data source such as csv, json etc) and use that file as DataSource.
    With that an additional step before Datasource would have to be added.
  • richie's avatar
    richie
    Community Hero
    4 years ago
    Hey wellaflex15,

    Im running v3.6.0 so i'll have a go at reproducing.

    From the screenshot it says >1 rows returned, but theres no data displayed. Is that right?

    Querybuilder functionality appears to be separate to manually inputting SQL in (at least thats the way it appears to work from other defects people have noticed).
    Have you tried manually inserting the SQL rather than use the querybuilder?

    Ta

    Rich
    • wellaflex15's avatar
      wellaflex15
      New Contributor
      4 years ago

      Hi richie! 

       

      Thanks for answering! 

       

      I've tried both. In the query builder(in there I can see the results) and by manually inserting the SQL and adding an own property. 

       

      Update I've had contact with my works support about this and I send them my test cases and they can run them and get results the way that I want to. I've tried to reinstall everything but I won't get it to work and the support guy are as confused as I am... 🙂

       

      Are there some configurations that needs to be set for JDBC-requests to work as a DataSource? 

      When I use a regular JDBC-step in my test case it works fine. 

       

      /David 

  • nmrao's avatar
    nmrao
    Champion Level 3
    4 years ago
    Nice and valid use case for data source.

    If you have show stopper, then following can be tried.
    Get the data from jdbc step and write the rows into a file(use a format supported by data source such as csv, json etc) and use that file as DataSource.
    With that an additional step before Datasource would have to be added.