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
Hi pb1,
It looks like this question requires some investigation. Could you please refer it to the Support Team?