Forum Discussion

micako's avatar
micako
New Contributor
15 years ago

Need Help Passing Property Values to JDBC Request

Hello,

I am relatively new to SoapUI and have come across an issue with passing property values to a JDBC request.

I have a set up a data source, using a grid with a property named 'Parameter'. There is 1 item (Foo) on that list.

I have then set up a JDBC request querying a mysql database. There is a property here (named 'searchParameter') with a value of ${DataSource#Parameter}

The query I am trying to run is essentially:

Select :searchParameter
from event

This only returns:

Results
ResultSet
@fetchSize 0
Row
@rowNumber 1
FOO "foo"

It appears that the property value is being passed in quotes - and I need to find a way to remove those quotes.

Does anyone have any ideas?
Thanks.

1 Reply

  • mandadavenkat's avatar
    mandadavenkat
    Occasional Contributor
    Don't include quotes neither in the parameters nor in the SQL statement.
    SOAP UI will take care of quotes.

    Best Regards
    Venkat