cancel
Showing results for 
Search instead for 
Did you mean: 

Blocking property expansion in JDBC step

SOLVED
Highlighted
Contributor

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Manager

Hi @pb1,

 

It looks like this question requires some investigation. Could you please refer it to the Support Team?

https://support.smartbear.com/message/?prod=ReadyAPI

---------
Tanya Gorbunova
SmartBear Community Manager

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today

View solution in original post

1 REPLY 1
Highlighted
Community Manager

Hi @pb1,

 

It looks like this question requires some investigation. Could you please refer it to the Support Team?

https://support.smartbear.com/message/?prod=ReadyAPI

---------
Tanya Gorbunova
SmartBear Community Manager

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
TechCorner Leaderboard
Want a fun and easy way to learn ReadyAPI and show off your skills? Try solving weekly TechCorner challenges and get into the Leaderboard!


Challenge Status

Get a full Raw JMS request

Participate!

Compare an expected JSON value and actual response in Events

Participate!

Fetch value/data from JSON response using Groovy Script

See replies!

Get data from Petstore and add it to Excel sheets

Participate!
Top Kudoed Authors