micako
15 years agoNew Contributor
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.
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.