Forum Discussion

VLiljeb_ck's avatar
VLiljeb_ck
Occasional Contributor
13 years ago

[Resolved] Error when using property in Sql query

I have my SoapUI project connected to a postgres database. I uses JDBC request to retrieve information from the database. When adding a property and run the sql query below I get an error message, "ER...
SmartBear_Suppo's avatar
SmartBear_Suppo
Icon for Alumni rankAlumni
13 years ago
Hi,

SoapUI sets the property value as text. In your case column b looks like an integer and I think that is why the comparison is failing. I would suggest try to cast your column like b::TEXT . That should probably work.

Regards,
Shadid
SmartBear Sweden