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

Re: Blocking property expansion in JDBC step

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

Re: Blocking property expansion in JDBC step

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

Compare an expected JSON value and actual response in Events

Participate!

Fetch value/data from JSON response using Groovy Script

See replies!

Filtering data retrieved from a DataSource

See replies!

Get data from Petstore and add it to Excel sheets

Participate!
Top Kudoed Authors