Forum Discussion

N78A's avatar
N78A
Contributor
7 years ago

Hi, I am trying to use a SQL query in JDBC oracle connection test step

Hi, I am trying to  execute SQL query using 'LIKE' operator in JDBC oracle connection test step   Details: I have defined property - "yearMonth" in JDBC test step . yearMonth is picking value from ...
nmrao's avatar
nmrao
Champion Level 3
7 years ago
N78A,

Not sure, but you can try as below:

Include "%" for the "yearMonth" value. And in the query, just mention parameter name.

Good luck.
  • N78A's avatar
    N78A
    Contributor
    7 years ago

    Hi nmrao,

     

    Thanks a lot for your response!

    But unfortunately I can not use '%' in value because I am fetching the data from test data file (which I am using to run my request) , so adding % in value will make the test data invalid and my request would fail. 

    basically I am trying to fetch the response for the 'customerId' for duration 'yearMonth'.  And then comparing the response with the data present in database for that particular customerId for that duration - yearMonth

     

    anything else you can suggest please ? 

     

      • N78A's avatar
        N78A
        Contributor
        7 years ago

        Hi ,

         

        Thanks again. I tried to understand the property expansion feature. Will come back once I do it. 

        thanks.