Forum Discussion

Dymitr's avatar
Dymitr
New Contributor
3 years ago

Data Source Properties doesn't populate with information from SQL query

Hi, I am currently using Ready API 3.10.1. I want to retrieve information from Oracle DB with "Data Source" test step and pass value to the property. I did next steps: 1."ojdbc8.jar" file was add...
  • Dymitr's avatar
    Dymitr
    3 years ago

    Hi, Richie.

    Thank you for your answer, but my issue was related with other things.

     

    I have read other sources and found the article.
    It says that you should add orai18n.jar to your classpath. This is related to the NLS parameters. I found this file in oracle maven repository and put it to the <installationFolder>\bin\ext.
    And property populate correctly. Next step of my test flow has got the value from data source variable.

richie's avatar
richie
Community Hero
Hey Dymitr,

I cant try and replicate this on mine cos i havent got a working db connecrion, but the fact that when you run the query manually means theres nothing wrong with the connection string/drivers/jre version etc.

Youve done exactly what i wouldve done (excepting building your query with the generator, its been problematic so i always just type in the query instead).

I have 2 points....both are total guesses

Im thinking theres either a problem with the property extraction (possible defect....i remember someone posting about 9 months ago about they were struggling to use properties in JDBC steps, so we had to use a workaround to sort it out WITHOUT using the properties)

Or. I noticed that your table names include a $ sign. This "might" be causing problems cos ReadyAPI typically considers strings following $ signs as parameters.

If you explain exactly what youre trying to do, i'll get my DB connection setup and i'll try and dig out the workaround to avoid using properties in JDBC steps.

Cheers

Rich

Dymitr's avatar
Dymitr
New Contributor
3 years ago

Hi, Richie.

Thank you for your answer, but my issue was related with other things.

 

I have read other sources and found the article.
It says that you should add orai18n.jar to your classpath. This is related to the NLS parameters. I found this file in oracle maven repository and put it to the <installationFolder>\bin\ext.
And property populate correctly. Next step of my test flow has got the value from data source variable.