I have a problem which I don't quite seem to get and therefore not sure about any solutions. I have in Soap UI a Data source that gets it's values from an excel sheet, now I try to check some of the data that has been manipulated via a CRM software and query the database with the DS values that looks like:
select * from payment where customer = :cid and payment_source = :bank
that select stays empty, but when I hardcode the last value select * from payment where customer = :cid and payment_source = 'FIRSTNAT' the data gets returned, so I assume that the JDBC doesn't know that the last value is a string. Is there any (easy) way to like tell jdbc or soap that that last thing is a string? I've read across forums and there's some toString()functions and some mentions of groovy scripts, but I'm totally blank in these corners of soap.