Forum Discussion

N78A's avatar
N78A
Contributor
7 years ago
Solved

Using like operator in JDBC soapui

Hi,   I am trying to run below query but it does not work.   select * from <table> where row_key like ':custId%'   where ":custId" is parametrized to fetch the custId from excel sheet...
  • N78A's avatar
    N78A
    7 years ago

    Problem is resolved, I used below query to use 'like' in soapui jdbc.

     

    SELECT * FROM (SELECT * FROM <table> where row_key like concat(:custId,'%') )

N78A's avatar
N78A
Contributor

Hi Justin,

Thanks for your reply but I am not picking anything from response. that is a seperate step, as of now I am trying to fetch the data against :custId  from oracle database [which in turn I am fetching from excel sheet (in JDBC test step by parameterizing) ]and trying to get records from oracle database after making a connectivity between JDBC step & my oracle database.

 

I just want to fetch the records from oracle database against custId defined in jdbc test step properties using "like".

N78A's avatar
N78A
Contributor
7 years ago

Problem is resolved, I used below query to use 'like' in soapui jdbc.

 

SELECT * FROM (SELECT * FROM <table> where row_key like concat(:custId,'%') )