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.

nmrao's avatar
nmrao
Champion Level 3
3 years ago

Do you get different result when the same query is executed from different tool?

  • richie's avatar
    richie
    Community Hero
    3 years ago
    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.

  • Dymitr's avatar
    Dymitr
    New Contributor
    3 years ago

    Dear nmao,

    Information from the Oracle DB was received and ReadyApi should have been passed this value to the properties. But in my case property is empty.

    My variable has a NULL value

    Like ${Data Source#V$IFOBS_TRANSACTIONS_ID} = ''