Forum Discussion

pb1's avatar
pb1
Contributor
5 years ago
Solved

Blocking property expansion in JDBC step

Hello

 

We are currently trying to update a timestamp in a postgresql database by using the JDBC step. We are running into problems regarding the property expansion that SoapUI provides, because our syntax looks something like this:

update <table> set insert_timestamp = insert_timestamp - '14 days'::interval

Now, SoapUI takes the ':interval' part and tries to resolve it to a value provided in the property list and expands it, which leads to it replacing it with a '?'. This means our query is rewritten into

update <table> set insert_timestamp = insert_timestamp - '14 days':?

 

How can we block this behaviour so we can keep the ::interval part? We already tried adding a property "interval" and setting its value to ":interval" to trick the program, but had no success.

 

Thanks for any help