cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
wellaflex15
New Contributor

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
nmrao
Community Hero

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

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.


Regards,
Rao.

View solution in original post

3 REPLIES 3
richie
Community Hero

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

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
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
wellaflex15
New Contributor

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

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
Community Hero

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

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.


Regards,
Rao.

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors